pROBLEM WITH TIMESTAMP

UDA
Highlighted
Enthusiast

pROBLEM WITH TIMESTAMP

Hi All,

I have a problem with timestamp. i have 2 coulmn with varchar as datatype. one is a date and the other is time. I need to concantinate these 2 fields and put it into a field which is TIMESTAMP data type. I am fine till i concantinate teh 2 field but when i am inserting into the time stamp field its giving a error.

Can please some one help me with this.

Regards
Hari
1 REPLY
Enthusiast

Re: pROBLEM WITH TIMESTAMP

You need to first find out what is the format of data in the varchar columns, then use appropriate format clause while inserting into timestamp column. If you can post your data format, we might be able to suggest something.