<@DSDATE>, <@DSTIME>, <@DSTIMESTAMP>

Syntax

<@DSDATE DATE=date [INFORMAT=informat] [ENCODING=encoding]>

<@DSTIME TIME=time [INFORMAT=informat] [ENCODING=encoding]>

<@DSTIMESTAMP TS=ts [INFORMAT=informat] [ENCODING=encoding]>

Description

These meta tags convert a date, time, or timestamp value to the format required by the current action's data source.

The main use for these tags is in Direct DBMS actions. In the other types of database actions (Search, Update, Insert, and Delete), Tango performs the required conversion automatically.

The DATE, TIME, and TS attributes are strings in the formats specified by the INFORMAT attribute. This attribute uses the same formatting codes as the date and time formatting configuration variables. If INFORMAT is omitted, the date, time, or timestamp value is assumed to be in the default format, specified by the dateFormat, timeFormat, and timestampFormat configuration variables with system scope, or the current user format, if assigned, using dateFormat, timeFormat, or timestampFormat (user scope).

These meta tags are valid only in actions associated with a data source.

Note:

Example

UPDATE myTable SET theDateColumn=<@DSDATE DATE=<@POSTARG NAME=theDate>>

This SQL example from a Direct DBMS action assumes that the date entered by the user into the date form field is in the format specified by dateFormat.

See Also

dateFormat, timeFormat, timestampFormat
Encoding Attribute
Format Attribute