Parameters
| s | character string containing a timestamp notation |
Since version:
6.0
Description
The Str2timestamp function converts the date entry from the s string into the Timestamp type value and returns the value. Empty string will be converted into NULL.
The s string must have one of the following formats:
day.month.year hour:minute:second
day.month.year hour:minute
day.month hour:minute:second
day.month hour:minute
If no year is specified, the current year will be taken.
You may also the similar CAST SQL function.
Function value
The function returns the timestamp entry if the timestamp notation is the (only) content of the s string, otherwise NULL.
See