date format

hi,

[Quoted] 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