Date from Timestamp

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Devendrudu
Participant
Posts: 31
Joined: Tue May 24, 2011 12:16 am

Date from Timestamp

Post by Devendrudu »

Hi,

How to get Date from Timestamp in Transformer.


please let me give your suggestions.
Devendra,Bangalore,India
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

Try this one.

date_from_timestamp(EnterYourTimeStampFieldHere)
Arvind
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

Also try TimestampToDate function
Arvind
Devendrudu
Participant
Posts: 31
Joined: Tue May 24, 2011 12:16 am

Post by Devendrudu »

arvind_ds wrote:Try this one.

date_from_timestamp(EnterYourTimeStampFieldHere)
Hi arvind,

where is date_from_timestamp in transformer functions.
Devendra,Bangalore,India
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

use TimestampToDate function in transformer.You can find it under Functions --> Type conversion.....
Arvind
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

date_from_timestamp() is a Modify stage function, not a Transformer stage function.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You can always tell the difference:

NiceLittleTransformerFunction()

nice_little_modify_function()
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can always tell the difference for data type conversion functions:
To
from
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That, too! :D
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply