Quick question for an ASP experts out there! I am reading a SQL database using ASP. The fieldtype in SQL is "datetime" ie. 2012-08-15 08:08:20.140However when I read this via Classic ASP ADODB RecordSet I get "15/08/2012". This is slightly un-helpful as I would like it to read in in the exact same format as it appears on SQL Server.Is there any way I can stop ASP changing the date and just read it in as it appears from SQL Server in YYYY-MM-DD format?
How to stop ASP automatically changing date type?
- Thread starter ChrisM
- Start date