NexusDB V3 Manual
Current Timestamp Function
|
|
NexusDB Manual V3 > SQL Reference > SQL Functions > DateTime Value Functions
|
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
|
|
© Nexus Database Systems Pty Ltd.