About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Labeled Durations

Expressions can be cast into an interval type by labeling the expression as a duration. This labeled duration
is represented by a numeric expression followed by one of the duration keywords. The supported labeled durations are DAY(S), MONTH(S), YEAR(S), HOUR(S), MINUTE(S), SECOND(S), and MICROSECOND(S).

The following table provides the possible labeled durations and resulting interval types:

Label	Result Type
<integer expression> DAYS (or DAY)	date interval
<integer expression> MONTHS (or MONTH)	date interval
<integer expression> YEARS (or YEAR)	date interval
<integer expression> HOURS (or HOUR)	time interval
<integer expression> MINUTES (or MINUTE)	time interval
<integer expression> SECONDS (or SECOND)	time interval
<decimal/float expression> SECONDS (or SECOND)	timestamp interval
<numeric expression> MICROSECONDS (or MICROSECOND)	timestamp interval

Examples

277 DAYS
(1024*1024-100) MINUTES
10e2 SECONDS

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

Labeled Durations

Labeled Durations

Examples