Please enable JavaScript to view this site.

 

Function

Description

AFTER

Add at time interval to a date, time or timestamp

BEFORE

Returns the value of a date, time or timestamp resulting from subtracting a specified number of days, months, years, minutes, hours and/or seconds

DATE2SMALLJUL

Converts a conventional date (YYYYMMDD) to small Julian date format (YYDDD)

DATEFMT

Formats a date value including conversion of two digit year to a four digit year

DATETIME

Returns the current date and time

DAY

Returns the day portion of a source date

DAYNAME

Returns the name of a day from its number (0 through 7)

DAYOFWEEK

Returns the day number from the current date

DAYS

Returns the number of days since 0000-03-01

GMT2LOCAL

Converts a GMT timestamp of the form YYYY-MM-DD-HH.MI.SS to the local timestamp

JULIAN

Derive a long Julian date value from a date

JULIAN2DATE

Converts long Julian date to a conventional date in YYYYMMDD format

LOCAL2GMT

Converts a GMT timestamp of the form YYYY-MM-DD-HH.MI.SS to the local timestamp

MONTH

Returns the month number from a date

MONTHNAME

Returns the name of the month from a month number

SECONDS

Converts the time value in HH:MM:SS into the equivalent number of seconds

SMALLJUL

Returns a small Julian date from the current date in YYDDD format

SMALLJUL2DATE

Converts a small Julian date (YYDDD) into a date formatted as YYMMDD

STORECLOCK

Returns the current eight byte Storeclock in a displayable hexadecimal character format of 16 bytes

TIME

Returns the current time in HH.MM.SS format

TIMESTAMP

Returns a timestamp value from the current date/time in YYYY-MM-DD-HH.MM.SS.mmmmmm format

TODAY

Returns the current date in YYYYMMDD format

WEEK

Returns the number of a week from a specified date in YYYYMMDD format

WEEKDAY

sqdedate.c

YEAR

Returns the current year value in YYYY format