Previous Topic

Next Topic

Book Contents

Book Index

Calculations on date time elements

The Calculate page for date time elements allows you to perform the following operations.

Date time operations

Operation

Description

- (difference)

The difference between the date in the report and another specified date.

- (difference in days)

The number of days between the date in the report and another specified date.

- (difference in months)

The number of months between the date in the report and another specified date.

- (difference in years)

The number of years between the date in the report and another specified date.

Add days

Specify the number of days to add to a date.

Add months

Specify the number of months to add to a date.

Add years

Specify the number of years to add to a date.

Earliest

Determine the earliest date between the date in the report and another specified date.

Latest

Determine the latest date between the date in the report and another specified date.

Year

Extract the year value from a date.

Month (number)

Extract the month value from a date.

Week

Extract the week value from a date.

Day

Extract the day value from a date.

Hour

Extract the hour value from a date.

Minute

Extract the minute value from a date.

Second

Extract the seconds value from a date.

Copyright © 2014 Oracle and/or its affiliates. All rights reserved.