Filemaker TH325Z/A Fiche technique télécharger pdf (Page 206)

206 FileMaker Functions Reference

Timestamp

Format

Timestamp(date;time)

Parameters

date - any calendar date or date field

time - any time value or time field

Data type returned

timestamp

Description

Returns a timestamp containing date as a calendar date and time as a time of day.

The format of the result depends on the date and time formats that were in use when the

database file was created. You can change the date and time formats in the Regional

Settings Control Panel (Windows 2000), the Date and Time Control Panel (Windows XP),

or the Date & Time System Preference (Mac OS).

Examples

Timestamp(Date(10;11;2004);Time(9;10;30)) returns 10/11/2004 9:10:30AM.

Timestamp(Date(10;11;2004);Time(13;10;30)) returns 10/11/2004

1:10:30PM.

Timestamp(Date(10;11;2004);Time(10;65;5)) returns 10/11/2004

11:05:05AM.

Timestamp(Date(10;35;2004);Time(4;5;6)) returns 11/4/2004 4:05:06AM.

1 2 ... 201 202 203 204 205 206 207 208 209 210 211 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 206