unix time format in Mysql

Question

Here I got a data like this: 1320609435.346877000, and I was told it was UNIX time which I do not understand. Shouldn't UNIX time look like an integer?

This data is stored in a txt as a column, if I want to insert this column into Mysql, which data type should I use and when I create a table, this default value should be assigned as NULL or ?

Many thanks!

Marco · Accepted Answer · 2011-11-23 10:55:29Z

1

In MySql I always prefer using DATETIME type.
So you could use:

INSERT INTO your_table (your_col)
    SELECT FROM_UNIXTIME(your_num)

See reference here.
Unix time you posted (1320609435.346877000) is 2011-11-06 20:57:15.

edited Nov 23, 2011 at 10:55

answered Nov 23, 2011 at 10:50

Marco

57.7k15 gold badges135 silver badges159 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

unix time format in Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related