Difference between revisions of "DTOS()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 37: Line 37:
 
[[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 string conversion


Syntax

DTOS(<expD> | <expT>)


See Also

AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), 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 DTOS() function converts the date expression <expD> or date part of the datetime expression <expT> to a character string in the format "YYYYMMDD". This function is particularly useful when creating indexes with mixed data types. The SET DATE, SET MARK and SET CENTURY settings have no effect on this function.


Example

? dtos({02/29/2004})
20040229
? dtos({02/29/2004 11:18:54 PM})
20040229
store dtos({02/29/2004})to m_date
? m_date
20040229
? type("m_date")
C


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer