Home >
database > SQLite database strange time problem, the timestamp shown as 1899...
SQLite database strange time problem, the timestamp shown as 1899...
Data from the firebird turned, create_date is a timestamp, directly select create_date was 1899/12/30 0:00:19, and select the replace (create_date, '/', '-') was the 2012-10-3 19:44:09, also is my data is turned on, but don't know what store became format sqlite treat it, tried to update into the 2012-10-3 19:44:09, results and select don't display, don't know how to fix the timestamp, give advice or comments please, thank you.