timestamp conversion

Training
Enthusiast

timestamp conversion

I have column having date in "2008-10-14 13:47:09" format. I need to convert this into "Unix epoch time" format (10-digit integer format). Is there a way to do this in Teradata ?
1 REPLY
Teradata Employee

Re: timestamp conversion

Hello,

There is no builtin way of doing it, but you can surely do this by using SQL or a UDF.

Regards,

Adeel