Timestamp
Purpose
Returns a timestamp containing a date as a calendar date and a time as a time of day.
Format
Timestamp(date;time)
Parameters
date - any calendar date or date
field time - any time value or time field
Data type returned
timestamp
Originated in
FileMaker Pro 7.0
Description
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 ; 2019 ) ; Time ( 9 ; 10 ; 30 ) ) returns 10/11/2019 9:10:30 AM.
Timestamp ( Date ( 10 ; 11 ; 2019 ) ; Time ( 13 ; 10 ; 30 ) ) returns 10/11/2019 1:10:30 PM.
Timestamp ( Date ( 10 ; 11 ; 2019 ) ; Time ( 10 ; 65 ; 5 ) ) returns 10/11/2019 11:05:05 AM.
Timestamp ( Date ( 10 ; 35 ; 2019 ) ; Time ( 4 ; 5 ; 6 ) ) returns 11/4/2019 4:05:06 AM.
Related topics