Convert Varchar2 to TimeStamp & Date to Timestamp

vsi · Post by **vsi** » Mon May 15, 2006 12:46 pm

Hi All,

I have 2 scenarios

1. I need to convert Date from Oracle to Timestamp

2.Varchar2 from XML to Timestamp

Thanks in Advance

aditya · Post by **aditya** » Mon May 15, 2006 12:52 pm

For scenarios 1) & 2) you could use a routine or transform

Just append the time as 00:00:00 at the end of the Date value.

HTH

Aditya.

diamondabhi · Post by **diamondabhi** » Mon May 15, 2006 12:52 pm

For:
1) use to_char in the sql
2) U can use iconv and oconv

Thanks,
Sai.

vsi · Post by **vsi** » Mon May 15, 2006 6:21 pm

I don't believe ,You guys are waiting to answer the new posts,Thanks a Lot!