Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Create/Generate epoch time from input Datetime field value in Informatica Cloud Data Integration task ?
Solution
To create a 'Epoch' datetime value we need a input datetime value or a datetime value generated in the mapping itself as a reference. 
User need to create a 'output field' in expression transformation. Lets name this field as 'EPOCHTIME' of datatype 'bigint' as shown in the below image.

2019-08-07 11_11_58-Informatica Cloud.png 
and configure a expression ,

DATE_DIFF(
    TO_DATE(<inputDateField>),
     TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),
'SS')
2019-08-07 11_36_32-Informatica Cloud.png

​​the above expression would calculate the seconds from 1970-01-01; creating 'epoch' time in seconds.

More Information
Reference
Applies To
Product: Cloud Data Integration
Problem Type: Configuration; Connectivity
User Type: Business User; Developer
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:8/7/2019 11:38 AMID:585617
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)