Main Menu

KB#00494-SQL Date Syntax example for ODBC Driver and SQL Engine

Title:

SQL Date Syntax example for ODBC Driver and SQL Engine

Description:

When trying to write dates in SQL (usually via the ODBC driver or PRO/5 SQL engine), the data must be in Julian format unless a special date syntax is used. Here is an example for each method. 

update table set field_date = '2450688' where ... 

or 

update table set field_date = {d 'yyyy-mm-dd'} where ... 

Note that if the above syntax is used, dates will be converted from yyyy-mm-dd to the Julian format. 



Last Modified: 02/23/2004 Product: BASIS ODBC Driver

BASIS structures five components of their technology into the BBx Generations.

  Google+ View BASIS LinkedIN ProfileVisit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel