Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: Enterprise
Expertise: Intermediate
Nov 6, 1998



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Interoperable Dates and Times in SQL Queries

Many developers using ODBC, JDBC, OLE DB, and ADO are unaware that there is a standards-compliant solution for expressing dates, times, and timestamps in SQL statements. When writing queries in proprietary SQL, developers find that porting their SQL code to a different platform often produces syntax errors. The Open Group, and subsequently the International Standards Organization, published standards that enable developers to express dates, times, and timestamps in an interoperable manner. Developers can use escape sequences with ODBC and JDBC drivers for Microsoft SQL Server, Oracle, Informix, IBM DB2, Sybase, and other SQL databases.

From the "Using Interoperable SQL" chapter of Database Magic with Ken North (Prentice-Hall PTR):

To specify a date, time, or timestamp escape sequence, substitute a value expression in the following clauses. The escape sequences for date, time, and timestamp values are:

{d'value'}			express a date value
{t'value'}			express a time
{ts'value'}			express a timestamp value.
SET BIRTHDATE={d '1953-12-23'}
Ken North
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date