Notification

This Help Center is moving to Cloud. Learn more about the migration.

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 Number field or expression representing the year.
  • month - a Number field or expression representing the month.
  • day - a Number 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

Example formula Output
DATETIME(2020, 1, 10, 05, 30, 00) 2020-1-10 05:30:00

Related resources

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu
13141971417021189747
true
Search Help Center
true
true
true
true
true
102097
false
false