[TOC] [Prev] [Next] [Bottom]

<@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).

Note: When a two-digit year is given, the following centuries are assumed:

For example, a two-digit year of 99 is evaluated as 1999, and a two-digit year of 00 is evaluated as 2000.

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

Note: These meta tags are not applicable to FileMaker Pro data sources (Mac OS) as the date and time string formats required for FileMaker Pro are determined by layout and system settings that may be unavailable to Tango.

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

[TOC] [Prev] [Next] [Bottom]

Copyright © 1999, Pervasive Software. All rights reserved.