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
-
Devendrudu
- Participant
- Posts: 31
- Joined: Tue May 24, 2011 12:16 am
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
- 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
- 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