[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
Date and Time Data Manipulation
-------------------------------------------------------------------------------
Reference Item| Description
|
CDOW() | Convert a date value to a character day of the week
CMONTH() | Convert a date to a character month name
CTOD() | Convert a date string to a date value
DATE() | Return the system date as a date value
DAY() | Return the day of the month as a numeric value
DOW() | Convert a date value to a numeric day of the week
DTOC() | Convert a date value to a character string
DTOS() | Convert a date value to a string formatted as yyyymmdd
EMPTY() | Determine if the result of an expression is empty
MAX() | Return the larger of two numeric or date values
MIN() | Return the smaller of two numeric or date values
MONTH() | Convert a date value to the number of the month
SECONDS() | Return the number of seconds elapsed since midnight
TIME() | Return the system time
TYPE() | Determine the type of an expression
VALTYPE() | Determine the data type returned by an expression
YEAR() | Convert a date value to the year as a numeric value
-------------------------------------------------------------------------------
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson