|
|
 Home->Support->Knowledge Base
|
|
|
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
|
|
|
