Temporal Types

RayforceDB offers 3 types of temporal types: Date, Time and Timestamp

Date

Scalar Type Code: -7. Scalar Internal Name: date. Vector Type Code: 7. Vector Internal Name: Date

Format: YYYY.MM.DD

↪ (type 2025.01.02)  ;; Scalar
date
↪ (type [2025.01.01 2025.01.02])  ;; Vector
Date
↪ (date 'local)  ;; local date
2025.12.10
↪ (date 'global)  ;; UTC date
2025.12.10

Time

Scalar Type Code: -8. Scalar Internal Name: time. Vector Type Code: 8. Vector Internal Name: Time

Format: HH:MM:SS.ms

↪ (type 20:00:00)  ;; Scalar
time
↪ (type [20:00:00 21:00:00])  ;; Vector
Time
↪ (time 'local)  ;; Get local time
14:15:56.273
↪ (time 'global)  ;; Get UTC time
12:16:10.426

Timestamp

Scalar Type Code: -9. Scalar Internal Name: timestamp. Vector Type Code: 9. Vector Internal Name: Timestamp

Format: YYYY.MM.DD\DHH:MM:SS.mmm

↪ (type 2025.12.10D15:10:24.058948000)  ;; Scalar
timestamp
↪ (type [2025.12.10D15:10:24.058948000 2025.12.10D15:10:24.058948000])  ;; Vector
Timestamp
↪ (timestamp 'local)  ;; Get local timestamp
2025.12.10D15:11:50.908518000
↪ (timestamp 'global)  ;; Get UTC timestamp
2025.12.10D15:12:00.695995000