Navigation:  NexusDB Guide > SQL Reference > SQL Functions > DateTime Value Functions >

Current Time Function

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Current Time Function

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Functions > DateTime Value Functions

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

 

© Nexus Database Systems Pty Ltd.

nexus_logo