Re: date format
From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/08/09
Message-ID: <8mrmok$5ja$1_at_s1.read.news.oleane.net>#1/1
Date: 2000/08/09
Message-ID: <8mrmok$5ja$1_at_s1.read.news.oleane.net>#1/1
Hello Sandy,
to_date(mydate||' '||myhour,'dd/mm/yyyy hh24:mi:ss') will do it.
-- [Quoted] Have a nice day Michel Sandy <daleelaNOdaSPAM_at_usa.net.invalid> a écrit dans le message : 0231a701.138ab11d_at_usw-ex0109-068.remarq.com...Received on Wed Aug 09 2000 - 00:00:00 CEST
> hi,
>
> From a form i get the date and the hour in separate fields.
> I would like to put them together to insert them in a table.
>
> mydate is in varchar2 (dd/mm/yyyy) and myhour (hh24:min:ss)
> in varchar2 and i would like to insert it as date.
>
> to_date(mydate||''||myhour,'dd/mm/yyyy') doesn't work
> How can i do ?
>
> thanks
>
> sandy
>
>
>
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images,
Audios, Videos, News, and Shopping. Smart is Beautiful