Home » RDBMS Server » Server Administration » Usage of Current_time() function
Usage of Current_time() function [message #374756] Thu, 28 June 2001 18:30 Go to next message
Alex Wong
Messages: 4
Registered: June 2001
Junior Member
Hi,

Can someone explain to me how to use the optional precision parameter of the CURRENT_TIME function? I tried this statement at SQL tutorial web site (http://www.sqlcourse2.com/), the returning columns appear to be identical.

select current_time(30), current_time(0), current_time() from customers

Thanks in advance.

Alex

Report message to a moderator

Re: Usage of Current_time() function [message #374762 is a reply to message #374756] Fri, 29 June 2001 06:16 Go to previous message
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
CURRENT_TIME is not a Oracle SQL-function, to get current time use SYSDATE.

Report message to a moderator

Previous Topic: Re: date handling
Next Topic: Re: help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 07:31:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.