Date settings

brekhof · Post by **brekhof** » Fri 03 Jun 2005 13:22

I want my program to be able to work with the date format 'dd-mm-yyyy' regardless of the workstation's regional settings. Is there a way to set the format to this for my MSSQL/SDAC components?

regards,
Martin

Ikar · Post by **Ikar** » Fri 03 Jun 2005 14:13

Usually you shouldn't do anything - Delphi performs all necessary operations automatically.

maciejw · Post by **maciejw** » Sat 11 Jun 2005 09:20

You can send date to MsSQL (or MSDE) in SQL STRING Format 'YYYYMMDD' which is translated to server for right form regardles of server date format.

f.e. MyQuery: TMsQuery;

MyQuery.SQL.Text := 'SELECT * FROM table_name WHERE date_field = ''19581207''';
MyQuery.Execute;

you receive records where date_field equals tp December 7th 1958.