to_date('1999-01-01','yyyy-mm-dd')
Jim
"Najm Hashmi" <najmh_at_videotron.ca> wrote in message
news:w8aw7.8113$Hw5.717744_at_weber.videotron.net...
> 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 Sun Oct 07 2001 - 23:57:51 CDT
