Current Timestamp Function

Wed, 03/04/2009 - 20:02 |  hdanzl


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
‹ Current Time FunctionupSystem Functions ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Functions | DateTime Value Functions

Powered by Drupal and Drupal Theme created with Artisteer.