Epoch Date Converter

Epoch Date Converter

Posted by: Partha Sen

An example of PowerCenter mapping to convert Epoch date or Unix date (an integer value) into actual local date time.

Overview

This mapplet can be used in any Informatica mapping that requires converting Epoch date or Unix date (an integer value) into actual local date time. Note :UNIX time or POSIX time, is a system for describing points in time, defined as the number of seconds elapsed since midnight proleptic Coordinated Universal Time (UTC) of January 1, 1970, not counting leap seconds. It is used widely, not only in Unix-like operating systems, but also in many other computing systems and file formats.More details about Epoch date or Unix date can be found online. As per Wikipedia:

Features

System Requirements:

  • Informatica PowerCenter 9.1 and 9.5
Informatica Product Requirements:
  • Assumes user to have basic Informatica knowledge of Repository Manager, Designer, Mapplets, expressions, etc.
  • Assumes basic SQL experience of user.

Resources

More details about Epoch date or Unix date can be found online. As per Wikipedia:UNIX time or POSIX time, is a system for describing points in time, defined as the number of seconds elapsed since midnight proleptic Coordinated Universal Time (UTC) of January 1, 1970, not counting leap seconds. It is used widely, not only in Unix-like operating systems, but also in many other computing systems and file formats. Source: http://en.wikipedia.org/wiki/Epoch_time

Support

Email: sen.partha.sen@gmail.com

Comments (2) Comment can only be posted by Signed/Logged in user

Sort: Newest | Oldest
  • Very nice work !!!! Couple of years back in one of our projects,we had a requirement to convert epoch date to local time but didnt know how to implement usign informatica instead we wrote a oracle function and used to call it in power center mappings.Nice work ...appreciate it !!!
  • Easy to use...
Recommended Products