The clause in SELECT statement to be used
to convert a dateetime stores as milliseconds from Epoch into a Date field.
CREATE TABLE tbl (myTime bigint(20));
INSERT INTO tbl VALUES (1343400240000);
SELECT FROM_UNIXTIME(myTime /1000) AS MyDate
FROM tbl;
0 comments:
Post a Comment