Difference between revisions of "TTOC()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=TTOC()=
 
 
 
 
==Class==
 
==Class==
 
Expressions and Type Conversion
 
Expressions and Type Conversion
Line 54: Line 51:
 
[[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 Functions]]

Revision as of 10:15, 2 June 2009

Class

Expressions and Type Conversion


Purpose

Function to convert a datetime expression to a string value in an optionally specified format


Syntax

TTOC(<expT> [, <expN>])


See Also

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


Description

The TTOC() function converts the datetime expression <expT> to a string value. By default, the date part of the string returned will conform to the current SET DATE, SET MARK and SET CENTURY settings, in the same format as DTOC(). The time will be returned in the format hh:mm:ss AM|PM. If the expression to be converted contains no time information, 12:00:00 AM will be assumed. If SET SECONDS is OFF (ON by default), no seconds will be displayed. The SET HOURS set command determines whether hours are shown in 24 hour format or in 12 hour format with AM | PM postfix.

<expN> The optional <expN> can be used to specify the format of the return value:


<expN> Format
0 As defaults
1 YYYYMMDDhhmmss
2 PM (SET SECONDS ON)

or hh:mm AM|PM (SET SECONDS OFF)


Example

set date american
? ttoc({^2004-03-29 10:15:43 AM})
03/29/2004 10:15:43 AM
? ttoc({^2004-03-29 10:15:43 AM},1)
20040329101543
? ttoc({^2004-03-29 10:15:43 AM},2)
10:15:43 AM


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer