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'

Current Functions

Technical documentation

» Table of Contents

» Index

Scope

SQL Syntax

Description

Examples