Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Timestamp functions > Timestamp function |
|
|
| Timestamp function |
| 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. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Timestamp functions > Timestamp function |
|
|
Next Page |
|