Description:
Convert a string or long integer to datetime value.
Syntax:
|
datetime(string) |
Convert string string into datetime value according to system-defined datetime format; return null if the conversion fails. |
|
datetime(string{, format }:loc) |
Convert the data type of string to datetime type according to the format defined by format and return null if the conversion fails; if parameter format doesn’t exist, the format of string of string type should be the same as the format of datetime value in configuration information; parameter loc is the language used in stringExp; the default is the system language. |
|
datetime(long) |
Convert long of long integer type to datetime value. |
|
datetime(date,time) |
Concatenate date type data and time type data into data of datetime type. |
|
datetime(y,m,d,h,m,s) |
Convert y,m,d,h,m,s of integer type to datetime data. |
Note:
The format of string should match format
Parameter:
|
string |
String. |
|
format |
Format string. |
|
loc |
Language name, which is case insensitive. The most commonly used languages are Chinese (zh) and English (en); see A.sort() to know other languages supported in esProc. |
|
long |
Long integer counted in microseconds. |
|
date |
Date type. |
|
time |
Time type. |
|
y |
Positive integer, year. |
|
m |
Positive integer, month. |
|
d |
Positive integer, day. |
|
h |
Positive integer, hour. |
|
m |
Positive integer, minute. |
|
s |
Positive integer, second. |
Return value:
Datetime
Example:
|
|
A |
|
|
1 |
=datetime("2006-01-01 10:20:30") |
2006-01-01 10:20:30 |
|
2 |
=datetime("12/28/1972 10:23:43","MM/dd/yyyy HH:mm:ss") |
1972-12-28 10:23:43 |
|
3 |
=datetime("2006-01-01 10:20:30:111") |
2006-01-01 10:20:30 |
|
4 |
=datetime(12345) |
1970-01-01 08:00:12 |
|
5 |
=datetime(date("1982-08-09"),time("12:12:12")) |
1982-08-09 12:12:12 |
|
6 |
=datetime(2006,01,01,-10,-20,30) |
2005-12-31 13:40:30 |
|
7 |
=datetime("4 五月 2001 3:08 下午","d MMM yyyy h:mm a":"zh") |
2001-05-04 15:08:00 |
Related function: