ToDate

Description

Convert input, based on format, to datetime data type.

Syntax

ToDate(milliseconds)

ToDate(datetime_string)

ToDate(custom_string, format)

ToDate(custom_string, format, timezone)

Arguments

  milliseconds - long. The number of milliseconds from 1970-01-01T00:00:00.000Z

  datetime_string - string expression in ISO 8601 format. If the value of the expression is not in the ISO 8601 format, an exception is thrown.

  custom_string - datetime value in a string expression in a custom format 

  format - format of the custom string. For formatting information, see http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html

  timezone - timezone information in either UTC offset or location based format

Examples


ToDate('2013-10-17T23:59:54.432Z') returns datetime value 2013-10-17T23:59:54.432Z

ToDate(0) returns datetime value 1970-01-01T00:00:00.000Z

ToDate('10/17/2013 23:59:54','MM/dd/yyyy HH:mm:ss') returns datetime value 2013-10-17T23:59:54.000Z

ToDate('10/17/2013 23:59:54','MM/dd/yyyy HH:mm:ss','+01:00') returns datetime value 2013-10-17T23:59:54.000+01:00

ToDate('Tue Jul 02 09:18:52 +0000 2013','EEE MMM dd HH:mm:ss Z yyyy') returns datetime value 2013-07-02T09:18:52.000Z (This is the datetime format used in Twitter stream).

Return value datatype

datetime

Notes

If format or timezone are null, an exception will be thrown.

Impact of null value

If milliseconds, iso8601_string or custom_string are null, returns null.

Feedback and Knowledge Base