Converting the source data into timestamp

[laknar]

Hi,

how to convert this into (13 NOV 2008 21:06) timestamp format

[swarnkar]

Hi,

how to convert this into (13 NOV 2008 21:06) timestamp format

Hi Laknar,

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".

[ray.wurlod]

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").