STOT()
From Lianjapedia
Revision as of 08:36, 3 October 2012 by Lianjasupport (Talk | contribs)
Contents
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