Hi,
how to convert this into (13 NOV 2008 21:06) timestamp format
Converting the source data into timestamp
Moderators: chulett, rschirm, roy
Re: Converting the source data into timestamp
Hi Laknar,laknar wrote:Hi,
how to convert this into (13 NOV 2008 21:06) timestamp format
first you have to convert it into internal format with help of Iconv Function. and then you can convert back this value to readable format by Oconv. Like
Oconv(Iconv(Field_Name[1,11],"D"),"D/YMD[4,2,2]"):" ":Field_Name[13,5]:":00"
So your output would be "2008/11/13 21:06:00".
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do tell. Iconv() and Oconv() are not available in parallel jobs. You will need to convert the date portion into a date and then back again to a string with a different format (StringToDate() and DateToString() functions) then concatenate the time portion and the seconds (":00").
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.