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.htco...@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 >
