General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Universal date format for SQL request
Hello,
From VFP8, I execute some SQL requests through ODBC.
The data sources can be SQL Server, DBF tables (odbc), MySQL, and so on...
A problem appears when I want to construct requests with dates.
According to the SQL system, the syntax for dates are different.
Ex.: ...where date='10-14-2004' works on SQL server but does not work with DBF tables.
Is there a 'universal' syntax which can work on all SQL systems ?
Any tips ?
Thanks for your help.
Regards,
Steph
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only