OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                     
 

2.70 FAQ-794 How do I import date data from database?

Last Update: 11/3/2015

When you import date columns from a database, you may find that the date format is lost. To keep the date format while importing,

  1. Select Tools: Options from Origin menu to open the Options dialog.
  2. Go to Numeric Format tab, select the appropriate format for the Date Format for Database Import drop-down list. You can also enter the custom date format in the edit box directly.

Keywords:importing, date format, ODCB, database, Oracle, MySql, SQL

 

© OriginLab Corporation. All rights reserved.