Difference between revisions of "DTOT()"

Latest revision as of 14:18, 14 June 2011

Purpose

Function to convert date to datetime

Syntax

DTOT(<expD>)

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

Description

The DTOT() function is the date to datetime conversion function. It converts the <expD> date expression specified to a datetime. The <expD> must be a valid date, or the DTOT() function will return an empty datetime. The time returned will be '12:00:00 AM' (12 hour) or '00:00:00' (24 hour).

Example

set date american
set century on
mdate = dtot({03/29/2010})
? mdate
03/29/2010 10:15:43 AM
? type("mdate")
T

Products

Recital, Recital Server