Current Time Function

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


Syntax

<current time value function> ::=

|

CURRENT_TIME

LOCALTIME


Notes

♦ The CURRENT_TIME function has an implicit time zone specification equal to the time offset on the server computer, and is therefore equivalent to LOCALTIME in this version of NexusDB SQL.
♦ The LOCALTIME function returns the local time on the server computer.


Examples

1) The following example selects all remaining appointments for today:

       SELECT *

       FROM appointments

       WHERE bookingDate = CURRENT_DATE AND apptTime >= CURRENT_TIME

Conformance

SQL:2003 standard

-

Core SQL
‹ Current Date FunctionupCurrent Timestamp Function ›
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.