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
Make Meals Easy
An easy way to put delicious meals together.Build Your Business
Get tips on starting up and staying competitive.Love Your Living Space
Achieve your dream home with advice from the pros.Financial Planning
Stay on top with our smart financial tips.
©2009 About.com, a part of The New York Times Company.
All rights reserved.