ALLBASE/SQL Reference Manual (36216-90216)

244 Chapter8
Expressions
Current Functions
Current Functions
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'