yydddffhhnnss format

[bhargav_dd]

Hi,

I have the data in the format yydddffhhnnss format where ff is a sequence number.

I need to convert that to date n time format.
The datatype in DB is timestamp.
Please help me.

How can i convert that. What function will i use..?
I used stringtodate for yyddd. But unable to get the data in right format

[ray.wurlod]

For the date portion use a format string of "%yy%ddd". You're on the right track.