Convert double to mysql date format

Question

In mysql, I had one table students and that table contains one column name as runtime and that contains values like 1381387683741, 1381387683739 etc.

when I convert this using covertor it shows results

Thu, 10 Oct 2013 06:48:03 GMT

So my question is how I can convert this same as using mysql query ?

score 1 · Answer 1 · answered Nov 29 '13 at 05:18

1

Use from_unixtime

SELECT
  from_unixtime(timestamp) 
FROM 
  your_table

answered Nov 29 '13 at 05:18

vijaykumar

4,658
6
37
54

column runtime data type is double when I run this query SELECT from_unixtime(runtime) FROM students; It shows results NULL – Neo-coder Nov 29 '13 at 05:49

Vishwas · Accepted Answer · 2013-11-29T07:15:58.460

0

Try this:

select from_unixtime(substring(runtime,1,10)) from students;

edited Nov 29 '13 at 07:15

answered Nov 29 '13 at 05:57

Vishwas

6,967
5
42
69

Convert double to mysql date format

2 Answers2