This function formats
the expression as a date and
time according to the string given as format-code.
If the format code is omitted, the date and time formats set in the operating
system are used.
Syntax:
Timestamp(expression [ ,
format-code ])
The examples below assume the following operating system settings:
Default setting
1
Default setting
2
Timestamp format
YY-MM-DD
M/D/YY
Example
Results
Setting 1
Setting 2
Timestamp(
A ) where
A=35648.375
String:
97-08-06
09:00:00
8/6/97
09:00:00
Number:
35648.375
35648.375
Timestamp(
A,'YYYY-MM-DD hh.mm') where A=35648
String:
1997-08-06
00.00
1997-08-06
00.00
Number:
35648
35648
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!