I want to get Regional date
and time
format for SQL Server.
I am using Delphi7 here. My scenario is as below:
If my server's regional date format is (e.g.) yyyymmdd
and client's SQL server is having mm/dd/yyyy
(or any other valid date format) than query generated should contain proper date format.
Note: I have code written in delphi7 which set default format for MSSQL and will read server's regional date format too. And will convert the server's regional date format to MSSQL date format.