Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date Formating Problem

Re: Date Formating Problem

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 08 Oct 2001 04:57:51 GMT
Message-ID: <jnaw7.18958$JN.68723@news1.sttls1.wa.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US