 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » Date and Time Functions » CURRENT_TIMESTAMP |
CURRENT_TIMESTAMPReturns the current timestamp.
Syntax
Returns
Usage
The CURRENT_TIMESTAMP function returns the current date and time. Use the UTC designation to indicate that the date and time returned should be a UTC (Coordinated Universal Time) value.
When this function is used with the ElevateDB Server, it will always return the current date/time for the ElevateDB Server machine.
Examples
SQL 2003 Standard Deviations
This function deviates from the SQL 2003 standard in the following ways:
Syntax
CURRENT_TIMESTAMP([UTC])
Returns
TIMESTAMP
Usage
The CURRENT_TIMESTAMP function returns the current date and time. Use the UTC designation to indicate that the date and time returned should be a UTC (Coordinated Universal Time) value.
When this function is used with the ElevateDB Server, it will always return the current date/time for the ElevateDB Server machine. Examples
INSERT INTO Logins VALUES (CURRENT_USER(), CURENT_TIMESTAMP())
SQL 2003 Standard Deviations
This function deviates from the SQL 2003 standard in the following ways:
| Deviation | Details |
| UTC Parameter | The UTC parameter is an ElevateDB extension. |
More Support Options
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
