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

Current Date Function

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Current Date Function

button_main button_prev button_next

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

Syntax

 

<current date value function> ::= CURRENT_DATE

 

 

Notes

 

§

The CURRENT_DATE function returns the system date on the server computer.

 

 

Examples

 

1)

The following example selects all future appointments:

 

      SELECT *

      FROM appointments

      WHERE bookingDate >= CURRENT_DATE

 

 


Conformance

 

SQL:2003 standard

-

Core SQL

 

© Nexus Database Systems Pty Ltd.

nexus_logo