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