Data Studio is now Looker Studio. Looker Studio is still free, with the same features you already know. Looker Studio Pro offers improved asset management for enterprises, new team collaboration capabilities, and access to technical support. Learn more.

DATETIME

Creates a date with time.

Sample usage

DATETIME(Year, Month, Day, Hour, Minute, Second)

Syntax

DATETIME(year, month, day, hour, minute, second)

Parameters

  • year - a numeric field or expression representing the year.
  • month - a numeric field or expression representing the month.
  • day - a numeric field or expression representing the day.
  • hour - a numeric field or expression representing the hour
  • minute - a numeric field or expression representing the minute.
  • second - a numeric field or expression representing the second.

Return data type

Date & Time

Examples

Formula Result
DATETIME(2020, 1, 10, 05, 30, 00) 2020-1-10 05:30:00

Related resources

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
102097
false
false