Here’s how to use datetime() function.
Description:
Adjust the precision of the datetime expression and return it.
Syntax:
datetime(datetimeExp)
Note:
The function adjusts the precision of datetimeExp and returns it. By default, the precision is the day.
Parameter:
|
datetimeExp |
Datetime value |
Option:
|
@m |
Accurate to minute |
|
@s |
Accurate to second |
|
@h |
Accurate to hour |
Return value:
Datetime value
Example:
|
|
A |
|
|
1 |
=datetime(now()) |
2013-12-09 00:00:00 |
|
2 |
=datetime@m(now()) |
2013-12-09 16:56:00 |
|
3 |
=datetime@s(now()) |
2013-12-09 16:56:45 |
|
4 |
=datetime@h(now()) |
2013-12-09 16:00:00 |
Related functions:
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 datatime 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 |
|
datetime(ym,d,h,m,s) |
Convert integer ym, d, h, m, s into 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 |
|
ym |
6-bit positive integer interpreted as year and 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(200601,01,-10,-20,30) |
2005-12-31 13:40:30 |
|
8 |
=datetime("4 五月 2001 3:08 下午","d MMM yyyy h:mm a":"zh") |
2001-05-04 15:08:00 |
Related function: