Part 3: The 32-Bit Drivers : The XML Driver : SQL Support : Grammar Token Definitions : Time and Date Literals

Time and Date Literals
Date, time, and timestamp literals are date, time, and timestamp values surrounded by a standard prefix and suffix. Date literals are specified in a YYYY-MM-DD format. Time literals are specified in an HH:MM:SS format with an optional fraction component. Timestamp literals are a concatenation of date and time values.
Examples for ODBC and SQL syntax are shown in the following table.
ODBC 1.x style ODBC escape sequences such as the following are not supported: --(*VENDOR(Microsoft), PRODUCT(ODBC) ...*)--

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.