datastage char(2006-03-04) to timestamp(2006-03-04:00:00:00)

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
karrisuresh
Participant
Posts: 57
Joined: Sat Jun 09, 2007 1:14 am
Location: chicago

datastage char(2006-03-04) to timestamp(2006-03-04:00:00:00)

Post by karrisuresh »

Hi My source column is char(10) and value is "2006-03-04"
Now My interest is to convert into timestamp 2006-03-04:00:00:00
can I get the exact syntax for this

src is dataset with datatype char 10
tgt is dataset with datatype timestamp


thanks
Suresh
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Timestamp datatype internal to Datastage would have micro seconds too.
You can concatinate the 0's and use the following function TimestampFromDateTime with this syntax %yyyy-%mm-%dd
%hh:%nn:%ss.x.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

TimestampFromString(), surely?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply