fc_curling
asked on
Set the dateformat to use for queries in an ADO connection
In Delphi the datetostring defaults to 'dd/mm/yyy'
The smalldatetime format on my sql server is 'yyyy/mm/dd hh:nn:ss'
My problem is that I can not be sure on the dateformat on the sqlserver if the application is run against a different server in a different country.
Can I somehow change the default dateformat on the adoconnection to use a specfic format so that I'm able to use a fixed formatdatetime format in my query ?
The smalldatetime format on my sql server is 'yyyy/mm/dd hh:nn:ss'
My problem is that I can not be sure on the dateformat on the sqlserver if the application is run against a different server in a different country.
Can I somehow change the default dateformat on the adoconnection to use a specfic format so that I'm able to use a fixed formatdatetime format in my query ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.