Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4

Description

DAYS_BETWEEN computes the difference between two dates in days.

Supported input column types: DATE

Output column type: FLOAT

DAYS_BETWEEN вычисляет разницу между двумя датами в днях.

Поддерживаемые типы входных столбцов: DATE

Тип выходного столбца: FLOAT

Syntax

DAYS_BETWEEN ( table.column1, table.column2 )

Null handling

If any parameter is NULL, the result is NULL

Если какой-либо параметр равен NULL, результат равен NULL.

Example

DAYS_BETWEEN of five rows.

DAYS_BETWEEN из пяти строк.

Query

Column1

DAYS_BETWEEN ( "Table1"."Column1" , "Table1"."Column2")

Input

Table1

Column1 : DATE	Column2 : DATE
Fri Dec 31 1999 23:59:59.000	Fri Dec 31 1999 23:59:59.000
Fri Dec 31 1999 23:59:59.000	Sun Jan 02 2000 00:01:02.000
Fri Dec 31 1999 23:59:59.000	Sat Jan 01 2000 12:01:00.000
Fri Dec 31 1999 23:59:59.000	Tue Jan 04 2000 00:00:00.000
Sat Jan 01 2000 12:01:00.000	Tue Jan 04 2000 00:00:00.000

Output

Result

Column1 : FLOAT

0.0

1.0007291666666667

0.5007060185185186

3.0000115740740743

2.4993055555555554

Содержание

1. Data Types
2. DATE
3. FLOAT
4. INT
5. STRING
6. Functions
7. Aggregation Functions
8. GLOBAL
9. Pull Up Aggregation Functions
10. PU_AVG
11. PU_COUNT
12. PU_COUNT_DISTINCT
13. PU_FIRST
14. PU_LAST
15. PU_MAX
16. PU_MEDIAN
17. PU_MIN
18. PU_QUANTILE
19. PU_SUM
20. Standard Aggregation Functions
21. AVG
22. COUNT
23. COUNT_TABLE
24. COUNT DISTINCT
25. MAX
26. MEDIAN
27. MIN
28. QUANTILE
29. STDEV
30. SUM
31. TRIMMED_MEAN
32. VAR
33. Moving Aggregation Functions
34. MOVING_AVG
35. MOVING_COUNT
36. MOVING_COUNT_DISTINCT
37. MOVING_MAX
38. MOVING_MEDIAN
39. MOVING_MIN
40. MOVING_STDEV
41. MOVING_SUM
42. MOVING_TRIMMED_MEAN
43. RUNNING_TOTAL
44. HOUR_NOW
45. TODAY
46. DATE_BETWEEN
47. DAYS_BETWEEN
48. HOURS_BETWEEN
49. MILLIS_BETWEEN
50. MINUTES_BETWEEN
51. MONTHS_BETWEEN
52. SECONDS_BETWEEN
53. WORKDAYS_BETWEEN
54. YEARS_BETWEEN
55. ADD_DAYS
56. ADD_HOURS
57. ADD_MILLIS
58. ADD_MINUTES
59. ADD_MONTHS
60. ADD_SECONDS
61. ADD_WORKDAYS
62. ADD_YEARS
63. CALENDAR_WEEK
64. DATE_MATCH
65. DAY
66. DAY_OF_WEEK
67. HOURS
68. MILLIS
69. MINUTES
70. MONTH
71. QUARTER
72. REMAP_TIMESTAMP
73. SECONDS
74. TO_TIMESTAMP
75. YEAR
76. DateTime Rounding Functions
77. ROUND_DAY
78. ROUND_HOUR
79. ROUND_MINUTE
80. ROUND_MONTH
81. ROUND_QUARTER
82. ROUND_SECOND
83. ROUND_WEEK
84. ROUND_YEAR
85. DECISION_TREE
86. KMEANS
87. LINEAR_REGRESSION
88. Math Functions
89. ABC
90. ABS
91. CEIL
92. FLOOR
93. LOG
94. POWER
95. ROUND
96. SQRT
97. SQUARE
98. ISNULL
99. Process Functions
100. ACTIVATION_COUNT
101. CALC_CROP
102. CALC_CROP_TO_NULL
103. CALC_REWORK
104. CALC_THROUGHPUT
105. MATCH_PROCESS
106. PROCESS_ORDER
107. PROCESS EQUALS
108. SOURCE / TARGET
109. VARIANT
110. Statistic Functions
111. QNORM
112. ZSCORE
113. CONCAT
114. LEFT
115. LEN
116. LOWER
117. LTRIM
118. REVERSE
119. RIGHT
120. RTRIM
121. STR_TO_INT
122. SUBSTRING
123. UPPER
124. Operators
125. CASE WHEN
126. FILTER
127. Math Operators
128. Addition Operator
129. Division Operator
130. MODULO
131. Multiplication Operator
132. Subtraction Operator
133. Predicate Operators
134. IN
135. LIKE
136. Ссылки на мануалы