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


dateFormat, timeFormat, timestampFormat

Valid in all scopes

These configuration variables allow you to specify the formats for displaying and entering date, time, and timestamp values. The formats determine the default display formats of retrieved database values as well as those returned by the <@CURRENTDATE>, <@CURRENTTIME>, and <@CURRENTTIMESTAMP> meta tags. Date, time, and timestamp values specified in Update and Insert actions, and those in criteria values must match the formats specified in these configuration variables. Tango converts these values to the formats required by the database.

Macintosh

! Note: On Macintosh, the default values for dateFormat, timeFormat, and timestampFormat, if they are not explicitly set, come from the Date & Time control panel of the computer running Tango.

FileMaker Pro

FileMaker Pro data sources only: These configuration variables determine how the date, time, and timestamp values returned by the <@CURRENTDATE>, <@CURRENTTIME>, and <@CURRENTTIMESTAMP> meta tags are formatted. Date, time, and timestamp values specified in Update and Insert actions, and those in criteria values must match the format specified in the Date & Time control panel of the Macintosh running the FileMaker Pro application.

For more information, see DATETIME.

To control the format of dates and times returned by FileMaker Pro, use the FORMAT attribute with the datetime: class of formatting.

The following table shows valid formatting codes.

Date and Time Formatting Codes

Code

Description

%a

abbreviated weekday name

%A

full weekday name

%b

abbreviated month name

%B

full month name

%c

local date and time representation

%d

day of month (01-31)

%H

hour (24 hour clock)

%I

hour (12 hour clock)

%j

day of the year (001-366)

%m

month (01-12)

%M

minute (00-59)

%p

local equivalent of AM or PM

%S

second (00-59)

%U

week number of the year (Sunday= first day of week) (00-53)

%w

weekday (0-6, Sunday is zero)

%W

week number of the year (Monday = first day of week) (00-53)

%x

local date representation

%X

local time representation

%y

year without century (00-99)

%Y

year with century

%%

% sign

Examples

If the following date and time formats were used on the twenty-eighth of July, 1998, at 6:30 PM:

%A, %B %d, %Y returns "Sunday, July 28, 1998"
%m/%d/%Y returns "07/28/1998"
%H:%M:%S returns "18:30:00"
%I:%M %p returns "6:30 PM"

! Note: If a date format string contains %Y, but the value for the year is two-digit, the following centuries are assumed, if appropriate:

Value

Century

00-36

2000s

37-99

1900s

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

The default values of the configuration variables are given in the following table:

Configuration Variable

Default Value

dateFormat

%m/%d/%Y

timeFormat

%H:%M:%S

timestampFormat

%m/%d/%Y %H:%M:%S.


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


docs@pervasive.com

Copyright © 1999, Pervasive Software. All rights reserved.