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


dateFormat, timeFormat, timestampFormat

Valid in all scopes

Tango Enterprise only: 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.

Mac OS

!Note: On Mac OS, 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 as first day of week) (00-53)

%w

weekday (0-6, Sunday is zero)

%W

week number of the year (Monday as 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"

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 © 1998, Pervasive Software Inc. All rights reserved.