Re: Date Functions

Hi

if You are using Oracle ...

cTime := TO_CHAR(my_date,'dd.mm.yyyy hh24:mi:ss'); dbms_output.put_line(cTime);

hth

Jan

"--B" <akshard_at_vsnl.com> schrieb im Newsbeitrag news:oo04a.23982$Vf3.273959_at_vixen.cso.uiuc.edu...
> Hi,
>
> I have a date column having value like '1/1/1900 2:30:00 PM'.
> Is there an easy way to get time in 24hr scale using some functions, for
> above example it should return '14:30'?
>
> Thanks,
>
> Akshar
>
>
Received on Mon Feb 17 2003 - 02:04:26 CST