Unix TimeStamp Convert

ArndW · Post by **ArndW** » Wed Apr 20, 2005 10:13 am

mkeevil,

the code I posted is a 1-liner that you can put right into your derivation in a TRANSform stage. Is that sufficient?

mkeevil · Post by **mkeevil** » Wed Apr 20, 2005 10:28 am

Ok so I created the function and a test batch.... I was just told though that the input date will be differnt, it will be '19-04-2005 00:00:00' so I would have to change the function to be
Ans = (iconv(datepiece,"D-DMY[,A3,]") - iconv("1 jan 1970","D"))

DEFFUN UnixTime(DateIn) Calling "DSU.UnixTime"

DateIn = '19-04-2005 00:00:00'
Result = UnixTime(DateIn)

Call DSLogInfo("Input Date: ":DateIn,"Batch::UnixConvertTest")
Call DSLogInfo("Converted: ":Result,"Batch::UnixConvertTest")

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 20, 2005 11:58 am

The iconv must be of format 'D-DMY[2,2,4]'.

mkeevil · Post by **mkeevil** » Wed Apr 20, 2005 12:16 pm

It worked correctly with both formats... Thanks for your help everyone.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 20, 2005 3:41 pm

Aren't there already SDK functions to deal with 1970-based dates?