I've got a 2005 MS SQL server with a datetime column. & i've got an IDM
driver inserting the time using Time (format=" dd/MM/yy kk:mm:ss")
Problem is somewere along the line the DD/MM are getting switched and the
sql server thinks that 11th Dec (11/12) = 12th November (12/11)
The DB stores the following timestamp and then interprets this as the date
oracle.sql.TIMESTAMP@10b81da = 11/12/2008 09:57:20
So, is my driver inserting the date incorrectly or is there a problem on the
SQL server side?
All servers are set to GMT.