Timestamp subtract

Supported in: Batch, Streaming

Subtract value from timestamp in specified unit.

Expression categories: Datetime

Declared arguments

• Timestamp: Timestamp that will be modified.
  Expression<Timestamp>
• Unit: Time unit.
  Enum<Days, Hours, Milliseconds, Minutes, Months, Quarters, Seconds, Weeks, Years>
• Value to subtract: Value that is subtracted from timestamp.
  Expression<Byte | Integer | Long | Short>

Output type: Timestamp

Examples

Example 1: Base case

Argument values:

• Timestamp: 2022-02-02T00:00:00Z
• Unit: DAYS
• Value to subtract: 1

Output: 2022-02-01T00:00:00Z

---

Example 2: Base case

Argument values:

• Timestamp: 2022-02-02T00:00:00Z
• Unit: HOURS
• Value to subtract: 2

Output: 2022-02-01T22:00:00Z

---

Example 3: Base case

Argument values:

• Timestamp: 2022-02-02T00:00:00Z
• Unit: MILLISECONDS
• Value to subtract: 2

Output: 2022-02-01T23:59:59.998Z

---

Example 4: Base case

Argument values:

• Timestamp: 2022-02-02T00:00:00Z
• Unit: MINUTES
• Value to subtract: 2

Output: 2022-02-01T23:58:00Z

---

Example 5: Base case

Argument values:

• Timestamp: 2022-02-01T00:00:00Z
• Unit: MONTHS
• Value to subtract: 2

Output: 2021-12-01T00:00:00Z

---

Example 6: Base case

Argument values:

• Timestamp: 2022-02-01T00:00:00Z
• Unit: QUARTERS
• Value to subtract: 2

Output: 2021-08-01T00:00:00Z

---

Example 7: Base case

Argument values:

• Timestamp: 2022-02-02T00:00:00Z
• Unit: SECONDS
• Value to subtract: 5

Output: 2022-02-01T23:59:55Z

---

Example 8: Base case

Argument values:

• Timestamp: 2022-02-01T00:00:00Z
• Unit: YEARS
• Value to subtract: 2

Output: 2020-02-01T00:00:00Z

---

Example 9: Null case

Argument values:

• Timestamp: date
• Unit: YEARS
• Value to subtract: value

---