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
Date settings
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.
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.