Timestamp from date is one of those data type conversions, which I occasionally have to do in DataStage but can never seem to remember. So, I thought I would write this quick post to document the data type conversion code, which is easy, once I finally remember how to do it again.
The TimestampFromDateTime Function
I use the TimestampFromDateTime(%date%,%time%) function to do this data type conversion. I’m sure there are other ways to achieve the result, but I find this method clean and easy to perform. The TimestampFromDateTime(%date%,%time%) function is in the Functions > Date & Time menu.
To populate the function, you need only add your date field on use ’00:00:00’ as your time element
Time Element example
TimestampFromDateTime(<<Date Field Here>>, ’00:00:00′)
Example transformer code With Date Field