mkdatetime(Y;M;D;HH;MM;SS)
Make a date+time (timestamp) value from year, month, day, hour, minute, and second numbers. (Available as of version 20.04)
Syntax
mkdatetime(Y;M;D;HH;MM;SS)Input
| Argument | Type | Description |
|---|---|---|
Y |
integer | A scalar value or the name of a column containing an integer, representing the year. |
M |
integer | A scalar value or the name of a column containing an integer, representing the month. |
D |
integer | A scalar value or the name of a column containing an integer, representing the day. |
HH |
integer | A scalar value or the name of a column containing an integer, representing the hour. |
MM |
integer | A scalar value or the name of a column containing an integer, representing the minute. |
SS |
integer or decimal | A scalar value or the name of a column containing an integer or floating-point value, representing the seconds (and fractional sections). |
Any of the above values except Y may be omitted or NA, which
will be treated as in mkdate() and mktime() (i.e.,
Y and M defaulting to 1, and
HH, MM, and SS defaulting
to 0.) If Y is omitted or is NA, the result is NA.
Return Value
Returns a floating-point value representing the timestamp (days since 2035-01-01).
For more information about date formats, see Dates and time.
If the input values are not in one of the supported formats listed above, the function returns an erroneous or illogical output.