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
Correct date format for SQL
By Zarko Gajic, About.com
Date values in SQL is always saved in "MM/DD/YY(YY)" format.
Suggested Reading
More Delphi TIPSDelphi Tutorials and ArticlesBeginners corner
Explore Delphi Programming
Must Reads
About.com Special Features
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.