dateExtract

Description

Returns an integer value that is the value of the specified date field within the given date. The field must be a string, and must match one of these values:

  • ms

  • second

  • sec

  • minute

  • min

  • hour

  • hr

  • day

  • week

  • month

  • year

  • dayofweek

  • dayofyear

Note: months are returned zero-indexed . That is, January is month 0, February is month 1, and so on. If this is inconvenient for you - just add one to the results.

Syntax

dateExtract( date, field )

Examples
 dateExtract(toDate("2003-9-14 8:00:00"), "year") //returns 2003
 dateExtract(toDate("2009-1-15 8:00:00"), "month") //returns 0
 dateExtract(toDate("2008-1-24 8:00:00"), "month") + 1 //returns 1