Your Digital Acceleration Starts Here Your Digital Acceleration Starts Here

DateTime Functions

ADD_TO_DATETIME
The function ADD_TO_DATETIME adds a given number of years, months, weeks...
DATE
The DATE function takes Numbers describing a year, month, and day; it us...
DATETIME
The function DATETIME combines the information contained in a given Date...
DATETIME_DELTA
The function DATETIME_DELTA returns returns the number of total years, t...
DATETIME_FROM_FORMAT
The DATETIME_FROM_FORMAT function takes a string representation of a dat...
DATETIME_FROM_TIMESTAMP
The TIMESTAMP_FROM_DATETIME function takes a timestamp – the number of m...
DATE_DELTA
The function DATE_DELTA returns returns the number of total years, total...
DATE_FROM_DATETIME
The function DATE_FROM_DATETIME takes a DateTime and returns the isolate...
DATE_FROM_FORMAT
The DATE_FROM_FORMAT function takes a string representation of a date an...
DAY
The function DAY returns the value of the day in a Date or DateTime. Thi...
DAYS
The function DAYS takes either two DateTimes or two Dates, and returns t...
FORMAT_DATE
The FORMAT_DATE function converts a Date into a String with two optional...
FORMAT_DATETIME
The FORMAT_DATETIME function converts a DateTime into a String with thre...
FORMAT_TIME
The FORMAT_DATE function converts a Time into a String with two optional...
HOUR
The function HOUR returns the value of the hour in a Time or DateTime. T...
ISO_WEEK
The function ISO_WEEK takes a Date or a DateTime and returns a Number in...
MINUTE
The function MINUTE returns the value of the minute in a Time or DateTim...
MONTH
The function MONTH returns the value of the month in a Date or DateTime....
NOW
The function NOW returns a DateTime corresponding with the date and mome...
SECOND
The function SECOND returns the value of the second in a Time or DateTim...
SUBTRACT_FROM_DATETIME
The function SUBTRACT_FROM_DATETIME subtracts a given number of years, m...
TIME
The TIME function takes Numbers describing an hour, minute, second, and ...
TIMESTAMP_FROM_DATETIME
The TIMESTAMP_FROM_DATETIME function returns the value of a DateTime in ...
TIME_DELTA
The function TIME_DELTA returns returns the number of total hours, total...
TIME_FROM_DATETIME
The function TIME_FROM_DATETIME takes a DateTime and returns the isolate...
TIME_FROM_FORMAT
The TIME_FROM_FORMAT function takes a string representation of a time an...
TODAY
Returns today as a date.DeclarationTODAY(time_zone) -> todayTODAY() -> t...
UPDATE_DATE
The function UPDATE_DATE replaces the date described by a DateTime with ...
UPDATE_DATETIME
The function UPDATE_DATETIME replaces the date and time described by a D...
UPDATE_DAY
The function UPDATE_DAY changes the day described by a Date or DateTime ...