Functions Reference

Chapter 15
|
Timestamp functions 203
Chapter 15
Timestamp functions
Timestamps are used for a wide variety of synchronization purposes, such as marking the
exact date and time at which a particular event occurred.
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 your operating
system.
Examples
Timestamp(Date(10;11;2008);Time(9;10;30)) returns 10/11/2008 9:10:30AM.
Timestamp(Date(10;11;2008);Time(13;10;30)) returns 10/11/2008
1:10:30PM.
Timestamp(Date(10;11;2008);Time(10;65;5)) returns 10/11/2008
11:05:05AM.
Timestamp(Date(10;35;2008);Time(4;5;6)) returns 11/4/2008 4:05:06AM.
This function Returns
Timestamp, page
203
A timestamp containing a calendar date and time of day.