Syntax

 

<current time value function> ::=

 

|

 

CURRENT_TIME

LOCALTIME

 

 

Notes

 

The CURRENT_TIME function has an implicit time zone specification equal to the time offset on the server computer, and is therefore equivalent to LOCALTIME in this version of NexusDB SQL.



 

The LOCALTIME function returns the local time on the server computer.



 

 

Examples

 

1)

The following example selects all remaining appointments for today:



 


SELECT *


FROM appointments


WHERE bookingDate = CURRENT_DATE AND apptTime >= CURRENT_TIME



 

 


 

Conformance

 

SQL:2003 standard

-

Core SQL