Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 42 Next »


Contents:

   

This example provides an overview on various date and time functions.

Functions:

ItemDescription
$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

$strPageTitle

Error rendering macro 'excerpt-include'

No link could be created for '$strPageTitle'.

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.

See Also for EXAMPLE - DATE and TIME Functions:

Error rendering macro 'contentbylabel'

parameters should not be empty

  • No labels

This page has no comments.