IBM PureData System for Analytics, Version 7.1

Date and time function reference

The date and time functions are organized alphabetically.

The day() function
The day() function returns the numeric value of the day of the month in a specified date.
The days_between() function
The days_between() function determines the truncated number of full days between two timestamps.
The hour() function
The hour() function determines the hours value in the specified time.
The hours_between() function
The hours_between() function determines the truncated number of full hours between two timestamps.
The minute() function
The minute() function determines the minutes value in the specified time.
The minutes_between() function
The minutes_between() function determines the truncated number of full minutes between two timestamps.
The month() function
The month() function determines the month in the specified date.
The next_week() function
The next_week() function determines the first day of the next week after the specified date. Sunday is considered the first day of that new week.
The next_month() function
The next_month() function determines the first day of the next month after the specified date.
The next_quarter() function
The next_quarter() function determines the first day of the next quarter after the date specified by the input.
The next_year() function
The next_year() function determines the first day of the next year after the date specified by the input.
The second() function
The second() function determines the seconds value in the specified time.
The seconds_between() function
The seconds_between() function determines the truncated number of full seconds between two timestamps.
The this_month() function
The this_month() function determines the first day of the month in the specified date.
The this_quarter() function
The this_quarter() function determines the first day of the quarter in which the specified date occurs.
The this_week() function
The this_week() function determines the first day of the week in the specified date.
The this_year() function
The this_year() function determines the first day of the year in the specified date.
The weeks_between() function
The weeks_between() function determines the truncated number of full weeks between two timestamps.
The year() function
The year() function determines the year in the specified date.