 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » Date and Time Functions » CURRENT_TIME |
CURRENT_TIMEReturns the current time.
Syntax
Returns
Usage
The CURRENT_TIME function returns the current time. Use the UTC designation to indicate that the 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 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_TIME([UTC])
Returns
TIME
Usage
The CURRENT_TIME function returns the current time. Use the UTC designation to indicate that the 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 time for the ElevateDB Server machine. Examples
INSERT INTO Logins VALUES (CURRENT_USER(), CURENT_DATE(), CURRENT_TIME())
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 |
