NexusDB V3 Manual
Current Time Function
|
|
NexusDB Manual V3 > SQL Reference > SQL Functions > DateTime Value Functions
|
Syntax
<current time value function> ::=
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
|
|
© Nexus Database Systems Pty Ltd.