Difference between revisions of "CMONTH()"

Revision as of 10:08, 2 June 2009

Class

Date and Time Data

Purpose

Function to return the character month from a specified date or datetime

Syntax

CMONTH(<expD> | <expT>)

See Also

AMPM(), CDOW(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EPOCH(), GOMONTH(), HOUR(), HOURS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, SET VAXTIME, STOD(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), VALIDTIME(), VTOD(), WEEK(), YEAR()

Description

CMONTH() is the character month function. It returns the name of the month from the specified date <expD> or the specified datetime <expT> as a character string.

Example

? cmonth(datetime())
October
? cmonth(date())
October
store cmonth(date()) to month
? month
October
? type("month")
C

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer