Syntax

 

<current timestamp value function> ::=

 

|

 

CURRENT_TIMESTAMP

LOCALTIMESTAMP

 

 

Notes

 

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



 

The LOCALTIMESTAMP function returns the system date and local time on the server computer.



 

 

Examples

 

1)

The following example selects all new appointments made today:



 


SELECT *


FROM appointments


WHERE bookingDate BETWEEN CURRENT_DATE AND CURRENT_TIMESTAMP



 

 


 

Conformance

 

SQL:2003 standard

-

Core SQL