DTOT()

From Recital Documentation Wiki
Jump to: navigation, search

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