Re: Selecting the current time

[Quoted] [Quoted] I think you'll find there is a TIME.

Connect as SYSTEM, and try "select Time from dual;"

[Quoted] DanHW wrote in message <20000215235131.01561.00001445_at_ng-fp1.aol.com>...
>>Does anyone know what privileges a User needs in order to "select Time
 from
>>dual"??
>>
>
>Try...
>select sysdate from dual
>
>there is no Oracle function TIME...
>
>If you want the time component of the date field, use the to_char function,
>with a date format...
>
>select to_char(sysdate,'HH24:MI:SS') from dual will return a string with
 the
>current time (in 24h notation)
>
>Dan Hekimian-Williams
Received on Wed Feb 16 2000 - 00:00:00 CET