Unix Time stamp to Mysql Time Stamp

bhavinultimate

• April 06, 2015 00:00

• Answered

Follow

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.

• 

  dpavlis

  • April 08, 2015 08:43

  0

  Comment actions Permalink

  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).

Please sign in to leave a comment.