MySQL time conversion uses Excel to implement MySQL timestamp format and date grid mutual transfer

Today the project table needs to import several w data, but the date is two one is the standard time a timestamp, the program search is based on time stamp to search, so in the online rummaging finally find the solution, using Excel to convert timestamp

A formula that turns a timestamp into a normal date:
b1= (a1+8*3600)/86400+70*365+19
Where A1 represents the 1249488000 value
Where B1 is the result you need, the B1 cell property is changed to date format.
The normal date is converted to a timestamp format formula:
a1= (c1-70*365-19) *86400-8*3600
Where C1 represents the 1249488000 value
Where A1 is the result you need, the A1 cell property date format is ready to go to the data format.

is to convert the standard time in C1 2012-2-10 10:30:00 to a timestamp formula a1= (c1-70*365-19) *86400-8*3600

Converts a timestamp in A1 to standard Time 2012-2-10 10:30:00

MySQL time conversion uses Excel to implement MySQL timestamp format and date grid mutual transfer