How to get SQL Server Date in its native format?
- by RoguePlanetoid
I need to get a Date from an SQL Server Database (SQL Server 2000), the date is stored as such:
2009-09-30 00:00:00.000
I want to pass this date into a Classic ASP function to use this date in the Database
somewhere else, however when I get the date, it converts in my ASP code to a locale-dependant version, such as:
30/09/2009
I just want the date as-is as formatting the date so it is correct again seems unnecessary, although if this the only way then fine - is there any way to treat it as string data so it stays like that, so it can be inserted back into the database as the same date, without needing conversion?