All Forums UDA
hari.k6 8 posts Joined 05/07
11 Jun 2007

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

joedsilva 505 posts Joined 07/05
12 Jun 2007

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.

You must sign in to leave a comment.