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 Guide
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
Holiday Central
What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >
Family Tech Center
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.