Thursday, 12 September 2013

Different format for timestamp when using c# datareader

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