Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

This example illustrates how the DATE and TIME functions operate. Both functions require that their outputs be formatted properly using the DATEFORMAT function.

  • DATE - Generates valid Datetime values from three integer inputs: year, month, and day. See DATE Function.
  • TIME - Generates valid Datetime values from three integer inputs: hour, minute, and second. See TIME Function.
  • DATETIME - Generates valid Datetime values from six integer inputs: year, month, day, hour, minute, and second. See DATETIME Function.
  • DATEFORMAT - Formats valid Datetime values according to the provided formatting string. See DATEFORMAT Function.

Source:

yearmonthdayhourminutesecond
20161011230
20151120152230
20141225183045

Transformation: 

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula DATEFORMAT(DATE (year, month, day),'yyyy-MM-dd')
Parameter: New column name 'fctn_date'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula DATEFORMAT(TIME (hour, minute, second),'HH-mm-ss')
Parameter: New column name 'fctn_time'

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula DATEFORMAT(DATETIME (year, month, day, hour, minute, second),'yyyy-MM-dd-HH:mm:ss')
Parameter: New column name 'fctn_datetime'


Results:

NOTE: All inputs must be inferred as Integer type and must be valid values for the specified input. For example, month values must be integers between 1 and 12, inclusive.

yearmonthdayhourminutesecondfctn_datefctn_timefctn_datetime
201610112302016-10-1102-03-002016-10-11-02:03:00
201511201522302015-11-2015-22-302015-11-20-15:22:30
201412251830452014-12-2518-30-452014-12-25-18:30:45

You can apply other date and time functions to the generated columns. For an example, see YEAR Function.

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 12 rates

This page has no comments.