Hi All, I have data in timestamp and following date format: yyyy-mm-dd
from postgresql. I am not sure how to convert it into oracle date format.
here is example:
INSERT INTO
songs(song_id,title,crh_id,artist_id,composer,performer,rel_date,flipr_rel_d
ate,file_size,hfile_size,description,highmd5,lowmd5,cat_id,shared,extrinfo)
VALUES (949,'Coffee
song',52,106,'Perpetuum','Perpetuum','1999-01-01',NULL,2911503,5823007,'Folk
Pop',NULL,NULL,'AMG',1,NULL);
I need to convert this date format into proper oracle date format. what is
the easiest way to do it. similary how can store timestamp in the date data
type.
Thanks in advance.
Regards,
Najm
Received on Mon Oct 08 2001 - 02:41:47 CDT
