Unix Time stamp to Mysql Time Stamp

CloverDX Platform
1

Hello,

I am reading date from csv file.Date format is Unix Time stamp so i am unable to choose date type in metadata.
Is there any way to convert Unix Time Stamp to any other Time stamp for ex yyyy-MM-dd HH:MM:SS.

Can anyone one help me out.

2

Hi,

Not sure, what you mean by Unix Time Stamp - if it is a number (number of seconds) like 1280512800 then you may use
long2date() CTL function to convert it to date. But make sure you multiply it by 1000 as long2date() expects the argument to be the number of milliseconds since the “epoch”, January 1, 1970, 00:00:00 GMT

Otherwise look at str2date() CTL function and its description (also description of all available date formats).