Difference between revisions of "STOT()"

Revision as of 08:27, 4 February 2013

Purpose

Function to perform string to datetime conversion

Syntax

STOT(<expC>)

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(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, STOD(), STR(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()

Description

The STOT() function converts the character expression <expC>, in the format "YYYYMMDDhhmmss", to a datetime. This function needs the century included in the character string even if SET CENTURY is OFF.

Example

? stot("20121003101509")
10/03/2012 10:15:09 AM