Re: Selecting the current time
From: DanHW <danhw_at_aol.com>
Date: 2000/02/16
Message-ID: <20000215235131.01561.00001445_at_ng-fp1.aol.com>#1/1
Date: 2000/02/16
Message-ID: <20000215235131.01561.00001445_at_ng-fp1.aol.com>#1/1
>Does anyone know what privileges a User needs in order to "select Time from
>dual"??
>
Try...
[Quoted] select sysdate from dual
[Quoted] 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 [Quoted] current time (in 24h notation)
Dan Hekimian-Williams Received on Wed Feb 16 2000 - 00:00:00 CET