Group Date / Time / Interval
CDow()
Converts a date value into the weekday name.
CDow( <dDate> ) --> cNameOfDay
CMonth()
Converts a date value into name of the month.
CMonth( <dDate> ) --> cMonth
CtoD()
Converts a date character string to a date value.
CtoD( <cDate> ) --> dDate
Date()
Retrieves system date.
Date() --> dSysDate
Day()
Returns the day of a date value as a numeric value.
Day( <dDate> ) --> nDayOfMonth
DoW()
Converts a date value to a numeric weekday.
DoW( <dDate> ) --> nDayOfWeek
DtoC()
Converts a date value to a character string.
DtoC( <dDate> ) --> cDate
DtoJ()
Converts a date value to a Julian date.
DToJ( <dDate> ) --> nJulianDate
DtoS()
Converts a date value to a character string in the format YYYYMMDD.
DtoS( <dDate> ) --> cDate
JtoD()
Converts a Julian date to a date value.
JToD( <nJulianDate> ) --> dDate
Max()
Determines the larger of two numeric or two date values.
Max( <ndExpression1>, <ndExpression2> ) --> ndMax
MicroSeconds()
Determines the number of microseconds that have elapsed since the last machine startup.
MicroSeconds() --> nMicroSeconds
MilliSeconds()
Determines the number of milliseconds that have elapsed since midnight.
MilliSeconds() --> nMilliSeconds
Min()
Determines the smaller of two numeric or two date values.
Min( <ndExpression1>, <ndExpression2> ) --> ndMin
Month()
Converts a date value into the numeric calender month.
Month( <dDate> ) --> nMonth
Seconds()
Determines the number of seconds that have elapsed since midnight.
Seconds() --> nSeconds
SET CENTURY
Sets whether display of years in date values will contain two or four digits.
SET CENTURY on | OFF | <lToggle>
SET DATE
Defines the date format for input and output.
SET DATE FORMAT [TO] <cDateFormat> SET DATE [TO] SYSTEM | american | ansi | british | french | german | italian | japan | usa
SET EPOCH
Determines how date values without century digits will be interpreted.
SET EPOCH TO <nYear>
SET TIME
Sets the display format for the system time
SET TIME TO HH:MM:SS | hh:MM:SS | hh:MM:SSTT | SYSTEM
StoD()
Converts a character string in the format YYYYMMDD to a date value.
StoD( <cDateString> ) --> dDate
Time()
Returns the system time as a formatted character string ("HH:MM:SS").
Time( [<cBaseZone>] ) --> cSystemTime
Year()
Extracts the year from a date value as a numeric value.
Year( <dDate> ) --> nYear