Date and Time Functions

Date and time functions set time zone parameters, date format code preferences, and define calenders.

• business()
  Scalar. Determines the next business day from a date value, based on a specified offset.
• businessday()
  Scalar. Determines if a date value falls on a business day (neither a weekend nor a holiday).
• date()
  Scalar. Converts a date value into an integer with the digits YYYYMMDD.
• dateceiling()
  Scalar. Computes a new date-time based on the provided date-time, multiple and date_part arguments, with subordinate date_parts set to zero. The result is then rounded up to the minimum date_part multiple that is greater than or equal to the input timestamp.
• datefloor()
  Scalar. Computes a new date-time based on the provided date-time, multiple and date_part arguments, with subordinate date_parts set to zero. The result is then rounded down to the maximum date_part multiple that is less than or equal to the input timestamp.
• dateint()
  Converts a date to an integer that represents the number of seconds since 1970-01-01 00:00:00 UTC (the Epoch).
• datename()
  Scalar. Converts a date value into a string.
• datepart()
  Scalar. Returns an integer representing a portion of a date.
• dateround()
  Scalar. Computes a new date-time based on the provided date-time, multiple and date_part arguments, with subordinate date_parts set to zero. The result is then rounded to the value of a date_part multiple that is nearest to the input timestamp.
• dayofmonth()
  Scalar. Returns the integer representing the day of the month extracted from a given bigdatetime.
• dayofweek()
  Scalar. Returns the integer representing the day of the week (Sunday is 1) extracted from a given bigdatetime.
• dayofyear()
  Scalar. Returns the integer representing the day of the year extracted from a given bigdatetime.
• gettimecolumnbyindex()
  Get the time value in a column that you specify using the column index.
• gettimecolumnbyname()
  Get the time value in a column that you specify using the column name.
• hour()
  Scalar. Returns an integer representing the hour extracted from a given bigdatetime.
• makebigdatetime()
  Scalar. Constructs a bigdatetime from the given values.
• microsecond()
  Scalar. Returns an integer representing the microsecond extracted from a given bigdatetime.
• minute()
  Scalar. Returns an integer representing the minutes extracted from a given bigdatetime.
• month()
  Scalar. Returns an integer representing the month extracted from a given bigdatetime.
• now()
  Returns the current system date as a bigdatetime value.
• second()
  Scalar. Returns an integer representing the seconds extracted from a given bigdatetime.
• sysbigdatetime()
  Returns the current system date as a bigdatetime value.
• sysdate()
  Scalar. Returns the current system date as a date value.
• systimestamp()
  Scalar. Returns the current system date as a timestamp value.
• to_time()
  Scalar. Converts a value to a time value.
• totimezone()
  Converts a date from the given time zone to a specified time zone.
• unbigdatetime()
  Scalar. Converts a given string into a bigdatetime value.
• undate()
  Scalar. Converts a given string into a date value.
• weekendday()
  Scalar. Determines if a given date/time type falls on a weekend.
• year()
  Scalar. Returns an integer representing the year extracted from a given bigdatetime.