1. Home
  2. Computing & Technology
  3. Delphi Programming

Correct date format for SQL

By Zarko Gajic, About.com

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

Zarko Gajic
Guide since 1998

Zarko Gajic
Delphi Programming Guide

Explore Delphi Programming
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 >

  1. Home
  2. Computing & Technology
  3. Delphi Programming
  4. Coding Delphi Applications
  5. Delphi Tips and Tricks
  6. 2003 Delphi Tips
  7. Correct date format for SQL

©2009 About.com, a part of The New York Times Company.

All rights reserved.