string to timestamp

saikiran · Post by **saikiran** » Sat Sep 13, 2008 3:49 pm

Hello DSgurus,

I need to convert the source column which is in format hh:nn:ss to timestamp.Souce is sequential file and the target is oracle table.Can anyone crack this

Thank you

ray.wurlod · Post by **ray.wurlod** » Sat Sep 13, 2008 4:06 pm

Can't you just wrap this in a TO_DATE function in the INSERT statement?

chulett · Post by **chulett** » Sat Sep 13, 2008 4:36 pm

hh:nn:ss? nn? Am I missing something or did you mean hh:mm:ss? And what are you planning on doing for a date... or did you mean an Oracle INTERVAL field rather than a TIMESTAMP?

ray.wurlod · Post by **ray.wurlod** » Sat Sep 13, 2008 10:03 pm

It's not necessary to have multiple threads open for the same question. Please delete your other post.

The easy choice is to add a date to the front of your time, then convert the whole to a timestamp.

Code: Select all

StringToTimestamp(DateToString(CurrentDate, "%yyyy-%mm-%dd") : " " : InLink.MyTime)

In this example I am assuming that your default timestamp format string is the usual default (YYYY-MM-DD HH24:MI:SS).

saikiran · Post by **saikiran** » Wed Sep 17, 2008 10:31 pm

ray.wurlod wrote:It's not necessary to have multiple threads open for the same question. Please delete your other post.

The easy choice is to add a date to the front of your time, then convert the whole to a timestamp.
Code: Select all
StringToTimestamp(DateToString(CurrentDate, "%yyyy-%mm-%dd") : " " : InLink.MyTime)
In this example I am assuming that your default timestamp format string is the usual default (YYYY-MM-DD HH24:MI:SS).

Hello,
The format i/p format is hh:mi:ss and the datatype is varchar .....My output should be the same but the datatype should be timestamp
Thank you
Sai

ray.wurlod · Post by **ray.wurlod** » Wed Sep 17, 2008 11:07 pm

You can't have a timestamp without a date component. What date do you want to use for the date component?