Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

Derives the full name from a Datetime value of the corresponding month as a String. Source value can be a reference to a column containing Datetime values or a literal.

NOTE: If the source Datetime value does not include a valid input for this function, a missing value is returned.

Wrangle vs. SQL: This function is part of Wrangle , a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

Basic Usage

monthname(MyDate)

Output: Returns the month name from the MyDate column.

Syntax and Arguments

monthname(datetime_col)


ArgumentRequired?Data TypeDescription
datetime_colYdatetimeName of column whose month name values are to be computed

For more information on syntax standards, see Language Documentation Syntax Notes.

datetime_col

Name of the column whose month name value is to be computed.

  • Missing values for this function in the source data result in missing values in the output.
  • Multiple columns and wildcards are not supported.

Usage Notes:

 

Required?Data TypeExample Value
YesDatetimemyDate

Examples

Tip: For additional examples, see Common Tasks.

Example - Date element functions

This example illustrates how a variety of date-related functions can be used to derive specific values out of a column of Datetime type.
  • YEAR - Returns the four-digit year value from a Datetime value. See YEAR Function.
  • MONTH - Returns the two-digit month value from a Datetime value. See MONTH Function.
  • MONTHNAME - Returns the full month name value from a Datetime value. See MONTHNAME Function.
  • WEEKDAYNAME - Returns the weekday name value from a Datetime value. See WEEKDAYNAME Function.
  • DAY - Returns the day of the month as a numeric value from a Datetime value. See DAY Function.
  • HOUR - Returns the hour value on a 24-hour scale from a Datetime value. See HOUR Function.
  • MINUTE - Returns the minutes value from a Datetime value. See MINUTE Function.
  • SECOND - Returns the seconds value from a Datetime value. See SECOND Function.

Source:

date
2/8/16 15:41
12/30/15 0:00
4/26/15 7:07

Transformation: 

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula YEAR (date)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula MONTH (date)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula MONTHNAME (date)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula WEEKDAYNAME (date)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula DAY (date)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula HOUR (date)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula MINUTE (date)

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula SECOND (date)

Results:

NOTE: If the source Datetime value does not contain a valid input for one of these functions, no value is returned. See the second_date column below.

dateyear_datemonth_datemonthname_dateweekdayname_dateday_datehour_dateminute_datesecond_date
2/8/16 15:4120162FebruaryMonday81541 
12/30/15 0:00201512DecemberWednesday3000 
4/26/15 7:0720154AprilSunday2677 

This page has no comments.