STOT()

From Lianjapedia
Revision as of 08:33, 3 October 2012 by Lianjasupport (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to perform string to datetime conversion

Syntax

STOT(<expC>)

See Also

CTOD(), DTOS(), SET CENTURY, STOD()

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