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

Current Timestamp Function

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Current Timestamp Function

button_main button_prev button_next

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.

nexus_logo