Skip to main content

15 docs tagged with "Date and Time"

View all tags

date

Converts a year, month, and day into a date.

date_add

Moves the given date by a specified interval.

date_diff

Returns the number of units (unit specified in Interval) between the input two dates.

date_range

Generates a range of dates between two dates.

day

Extracts the day from a date value.

floor_date

Takes a date-time and rounds it down to the nearest date-time value of the specified time unit.

format

Converts a value to text in the specified format.

hour

Extracts the hour from a datetime value.

month

Extracts the month from a date value.

now

Returns the current date and time.

quarter

Extracts the quarter from a date value.

week

Extracts the week number from a date value.

weekday

Returns a number representing the day of the week of the date provided.

year

Extracts the year from a date value.