[<<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