Different format for timestamp when using c# datareader
I'm reading a timestamp from a mysql table using an OdbcDataReader. When I
look at the data in the table it is in the format 2013-09-12 11:11:09. But
the reader seems to read it in the format 12/09/2013 11:11:09.
I then try to insert this into another mysql table but receive the error:
Incorrect datetime value: '12/09/2013 11:11:09' for column 'timestamp' at
row 1
How can I sort out this difference in formatting? Should I be referencing
some Unix timestamp value somehow?
No comments:
Post a Comment