 |
» |
|
|
|
Current functions return a value that represents a current DATE,
TIME, or DATETIME. The value returned is a string with the format of a
DATE, TIME, or DATETIME data type. Scope | |
SQL Data Manipulation Statements SQL Syntax | |
{ CURRENT_DATE CURRENT_TIME CURRENT_DATETIME } Description | |
CURRENT_DATE returns the current date as a string of the
form 'YYYY-MM-DD', where YYYY represents the year, MM is the month, and
DD is the day.
CURRENT_TIME returns the current time as a string of the
form 'HH:MI:SS', where HH represents hours, MI is minutes,
and SS is seconds.
CURRENT_DATETIME returns the current date and time as a
string of the form 'YYYY-MM-DD HH:MI:SS.FFF', where YYYY represents the
year, MM is the month, DD is the day, HH represents the hours, MI the
minutes, SS the seconds, and FFF the thousandths of a second.
Examples | |
Set a column to the current DATE.
UPDATE ManufDB.TestData
SET TestDate = CURRENT_DATE
WHERE BatchStamp = '1984-07-25 10:15:58.159'
|
Set a column to the current DATETIME.
UPDATE ManufDB.SupplyBatches
SET BatchStamp = CURRENT_DATETIME
WHERE BatchStamp = '1984-07-25 10:15:58.159'
|
|
