Difference between revisions of "DTOC()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 40: Line 40:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Expressions and Type Conversion]]
 +
[[Category:Expressions and Type Conversion Functions]]
 
[[Category:Date and Time Data]]
 
[[Category:Date and Time Data]]
 
[[Category:Date and Time Data Functions]]
 
[[Category:Date and Time Data Functions]]

Revision as of 10:12, 2 June 2009

Class

Expressions and Type Conversion


Purpose

Function to perform date to character conversion


Syntax

DTOC(<expD> | <expT> [,1])


See Also

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

Description

The DTOC() function converts the date expression <expD> or date part of the datetime expression <expT> to a character string in the format of the current SET DATE, SET MARK and SET CENTURY settings. For example, the default settings, SET DATE AMERICAN, and SET CENTURY ON, will return a date in the format "MM/DD/YYYY".

If the optional 1 is specified, the date will be returned in DTOS() format, suitable for index key purposes.


Example

? dtoc({02/29/2004})
02/29/2004
? dtoc({02/29/2004 10:34:21 A.M.})
02/29/2004
? dtoc({02/29/2004},1)
20040229
store dtoc({02/29/2004}) to m_date
? m_date
02/29/2004
? type("m_date")
C


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer