drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divya Gehlot <divya.htco...@gmail.com>
Subject Re: convert epoch time stamp to timestamp
Date Mon, 15 Jan 2018 07:16:05 GMT
When I
SELECT
CAST(FROM_UNIXTIME(t.`timestamp`) AS TIMESTAMP) AS `timestamp`
FROM
path/data/file  t limit 10 ;

49995-02-13T19:51:48.000Z
49995-04-22T15:47:05.000Z
49996-09-06T03:21:25.000Z
49997-03-05T01:20:19.000Z

I get these values .

Thanks,
Divya

On 15 January 2018 at 15:09, Divya Gehlot <divya.htconex@gmail.com> wrote:

> Hi ,
> One of field in my data file is  in epoch time stamp .
> The values would be similar like 1515545336591
>
> How can I convert this to 'YYYY-MM-DD HH:mm:ss' format .
>
> Thanks,
> Divya
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message