How to use interval in oracle

The INTERVAL data type in Oracle is used to represent time intervals. The syntax is INTERVAL <unit>. You can use addition, subtraction, multiplication and division operations to operate INTERVAL, which is suitable for storing time data and calculating date differences. Worth waiting for the scene. </p></blockquote> <p><img src="https://img.php.cn/upload/article/202405/08/2024050819541996627.jpg" alt="How to use interval in oracle" ></p> <p><strong>Usage of INTERVAL in Oracle</strong></p> <p>In Oracle, the INTERVAL data type is used to represent time intervals. It's great for storing and manipulating time data. </p> <p><strong>Syntax for INTERVAL</strong></p> <pre class="brush:php;toolbar:false"><code>INTERVAL <精度> <单位></code>

Where:

• Precision is the number of decimal places for the INTERVAL value.

• Unit Specify the unit of the time interval, which can be:

  • YEAR: year
  • MONTH: month
  • DAY：Day
  • HOUR：Hour
  • MINUTE：Minute
  • SECOND：Second
  • YEAR TO MONTH：Year to month
  • DAY TO HOUR：Day to minute
  • DAY TO MINUTE：Day to minute
  • DAY TO SECOND：Day to second

Create INTERVAL

You can create INTERVAL using the following syntax:

<code>CAST(<值> AS INTERVAL <单位>)</code>

For example:

<code>CAST('1' AS INTERVAL YEAR)  -- 创建一个间隔 1 年的值
CAST('-2' AS INTERVAL MONTH) -- 创建一个间隔 2 个月的负值</code>

Operation INTERVAL

INTERVAL can be operated on using arithmetic operators:

• Addition ( ): Increase the time interval.
• Subtraction (-): Reduce the time interval.
• Multiplication (*): Multiply the time interval by a number.
• Division (/): Divide the time interval by a number.

For example:

<code>INTERVAL '1' YEAR + INTERVAL '3' MONTH -- 增加一个时间间隔，间隔为 1 年 3 个月
INTERVAL '2' DAY - INTERVAL '1' DAY -- 减小一个时间间隔，间隔为 1 天
3 * INTERVAL '1' HOUR -- 将时间间隔乘以 3，间隔为 3 小时
INTERVAL '1' DAY / 2 -- 将时间间隔除以 2，间隔为 12 小时</code>

USE INTERVAL

INTERVAL can be used for many purposes, including:

• Storage and operating time data.
• Calculate the difference between date and time.
• Create time-based triggers or constraints.

The above is the detailed content of How to use interval in oracle. For more information, please follow other related articles on the PHP Chinese website!