Correct date format for SQL
Date values in SQL is always saved in "MM/DD/YY(YY)" format.
Here's a line of code to get the string in the correct format for SQL:
FormatDateTime('mm"/"dd"/"yyyy', Now)
Delphi tips navigator:
» Delphi application that copies itself
« Kylix - Execute an application
Here's a line of code to get the string in the correct format for SQL:
FormatDateTime('mm"/"dd"/"yyyy', Now)
Delphi tips navigator:
» Delphi application that copies itself
« Kylix - Execute an application
Source...