DateTime

Description of formula:
DATETIME function creates datetime from specified values. Function make possible to convert date or datetime UTC to datetime.
Syntax:
DATETIME(year,month,day,hour,minute,second,[milisecond])
or
DATETIME(date)
or
DATETIME(date,hour,minute,second,[milisecond])
or
DATETIME(UTC)
Parameters:
year(type:number)
The value of the year may contain from one to four digits. 
month(type:number)
Number ranging from 1 to 12, which is the month of the year (January to December).
day(type:Number)
Number ranging from 1 to 31, which means the day of the month.
hour(type:number)
Number ranging from 0 to 23, which means the hour of the day.
minute(type:number)
Number ranging from 0 to 59, which means the minute of the hour.
second(type:number)
Number ranging from 0 to 59, which means the second of the minute.
millisecond (type:number)
- optional
date(type:date)
If only parametr in formula is date, formula return time: 12AM
UTC(type:UTC)
Datetime UTC, you want to convert to datetime
Returned type:
DateTime
=datetime(2016,1,1,1,1,1)
=datetime(2016,1,1,1,1,1,1)
=datetime(section1.A1, section1.A2, section1.A3, section1.A4, section1.A5, section1.A6) =datetime(A3)
=datetime(date(2016,1,1))
=datetime(utc(now())
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk