The datetime is saved as yyyy-mm-dd hh:mm:sec (ODBC canonical form) format .
When I query the database in SQL Management Studio, it gives the same format as that of in database
When I use ADO member in my code to get the recordset, it gives the value in regional specific formate. i.e. since my machine is configured for English(U.S.), the output from ADO is mm/dd/yyyy hh:mm:sec
Is there anyway i can get the valu in ODBC canonical form?
adboCmd->Execute(NULL, NULL, noRecords)