STOT()

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

Jump to: navigation, search

Purpose

Function to perform string to datetime conversion

Syntax

STOT(<expC>)

See Also

CTOD(), CTOT(), 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