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
datastage char(2006-03-04) to timestamp(2006-03-04:00:00:00)
Moderators: chulett, rschirm, roy
-
- 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)
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
hope we all help each other hand in hand
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: