← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_sapdb.result

Phase 1 - temporal changes

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_sapdb.result
85
85
select makedate(100,1);
86
86
makedate(100,1)
87
87
0100-01-01
88
 
select addtime("1997-12-31 23:59:59.999999", "1 1:1:1.000002");
89
 
addtime("1997-12-31 23:59:59.999999", "1 1:1:1.000002")
90
 
1998-01-02 01:01:01.000001
91
88
select subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002");
92
89
subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002")
93
90
1997-12-30 22:58:57.999999
94
 
select addtime("1997-12-31 23:59:59.999999", "1998-01-01 01:01:01.999999");
95
 
addtime("1997-12-31 23:59:59.999999", "1998-01-01 01:01:01.999999")
96
 
NULL
97
91
select subtime("1997-12-31 23:59:59.999999", "1998-01-01 01:01:01.999999");
98
92
subtime("1997-12-31 23:59:59.999999", "1998-01-01 01:01:01.999999")
99
93
NULL
103
97
select subtime("02:01:01.999999", "01:01:01.999999");
104
98
subtime("02:01:01.999999", "01:01:01.999999")
105
99
01:00:00.000000
106
 
select timediff("1997-01-01 23:59:59.000001","1995-12-31 23:59:59.000002");
107
 
timediff("1997-01-01 23:59:59.000001","1995-12-31 23:59:59.000002")
108
 
838:59:59
109
 
Warnings:
110
 
Warning 1292    Truncated incorrect time value: '8807:59:59.999999'
111
 
select timediff("1997-12-31 23:59:59.000001","1997-12-30 01:01:01.000002");
112
 
timediff("1997-12-31 23:59:59.000001","1997-12-30 01:01:01.000002")
113
 
46:58:57.999999
114
 
select timediff("1997-12-30 23:59:59.000001","1997-12-31 23:59:59.000002");
115
 
timediff("1997-12-30 23:59:59.000001","1997-12-31 23:59:59.000002")
116
 
-24:00:00.000001
117
 
select timediff("1997-12-31 23:59:59.000001","23:59:59.000001");
118
 
timediff("1997-12-31 23:59:59.000001","23:59:59.000001")
119
 
NULL
120
 
select timediff("2000:01:01 00:00:00", "2000:01:01 00:00:00.000001");
121
 
timediff("2000:01:01 00:00:00", "2000:01:01 00:00:00.000001")
122
 
-00:00:00.000001
123
 
select timediff("2005-01-11 15:48:49.999999", "2005-01-11 15:48:50");
124
 
timediff("2005-01-11 15:48:49.999999", "2005-01-11 15:48:50")
125
 
-00:00:00.000001
126
 
select maketime(10,11,12);
127
 
maketime(10,11,12)
128
 
10:11:12
129
 
select maketime(25,11,12);
130
 
maketime(25,11,12)
131
 
25:11:12
132
 
select maketime(-25,11,12);
133
 
maketime(-25,11,12)
134
 
-25:11:12
135
100
select timestamp("2001-12-01", "01:01:01.999999");
136
101
timestamp("2001-12-01", "01:01:01.999999")
137
102
2001-12-01 01:01:01.999999
160
125
NULL
161
126
Warnings:
162
127
Warning 1292    Incorrect datetime value: '1997-13-31 23:59:59.000001'
163
 
select time("1997-12-31 23:59:59.000001");
164
 
time("1997-12-31 23:59:59.000001")
165
 
23:59:59.000001
166
 
select time("1997-12-31 25:59:59.000001");
167
 
time("1997-12-31 25:59:59.000001")
168
 
NULL
169
 
Warnings:
170
 
Warning 1292    Truncated incorrect time value: '1997-12-31 25:59:59.000001'
171
128
select microsecond("1997-12-31 23:59:59.000001");
172
129
microsecond("1997-12-31 23:59:59.000001")
173
130
1
174
131
create table t1 
175
132
select makedate(1997,1) as f1,
176
 
addtime(cast("1997-12-31 23:59:59.000001" as datetime), "1 1:1:1.000002") as f2,
177
 
addtime(cast("23:59:59.999999" as time) , "1 1:1:1.000002") as f3,
178
 
timediff("1997-12-31 23:59:59.000001","1997-12-30 01:01:01.000002") as f4,
179
 
timediff("1997-12-30 23:59:59.000001","1997-12-31 23:59:59.000002") as f5,
180
 
maketime(10,11,12) as f6,
181
133
timestamp(cast("2001-12-01" as date), "01:01:01") as f7,
182
 
date("1997-12-31 23:59:59.000001") as f8,
183
 
time("1997-12-31 23:59:59.000001") as f9;
 
134
date("1997-12-31 23:59:59.000001") as f8;
184
135
describe t1;
185
136
Field   Type    Null    Key     Default Extra
186
137
f1      date    YES             NULL    
187
 
f2      datetime        YES             NULL    
188
 
f3      time    YES             NULL    
189
 
f4      time    YES             NULL    
190
 
f5      time    YES             NULL    
191
 
f6      time    YES             NULL    
192
138
f7      datetime        YES             NULL    
193
139
f8      date    YES             NULL    
194
 
f9      time    YES             NULL    
195
140
select * from t1;
196
 
f1      f2      f3      f4      f5      f6      f7      f8      f9
197
 
1997-01-01      1998-01-02 01:01:00     49:01:01        46:58:57        -24:00:00       10:11:12        2001-12-01 01:01:01     1997-12-31      23:59:59
198
 
create table test(t1 datetime, t2 time, t3 time, t4 datetime);
 
141
f1      f7      f8
 
142
1997-01-01      2001-12-01 01:01:01     1997-12-31
 
143
create table test(t1 datetime, t4 datetime);
199
144
insert into test values 
200
 
('2001-01-01 01:01:01', '01:01:01', null, '2001-02-01 01:01:01'),
201
 
('2001-01-01 01:01:01', '-01:01:01', '-23:59:59', "1997-12-31 23:59:59.000001"),
202
 
('1997-12-31 23:59:59.000001', '-23:59:59', '-01:01:01', '2001-01-01 01:01:01'),
203
 
('2001-01-01 01:01:01', '01:01:01', '-1 01:01:01', null),
204
 
('2001-01-01 01:01:01', '-01:01:01', '1 01:01:01', '2001-01-01 01:01:01'),
205
 
('2001-01-01 01:01:01', null, '-1 01:01:01', null),
206
 
(null, null, null, null),
207
 
('2001-01-01 01:01:01', '01:01:01', '1 01:01:01', '2001-01-01 01:01:01');
208
 
SELECT ADDTIME(t1,t2) As ttt, ADDTIME(t2, t3) As qqq from test;
209
 
ttt     qqq
210
 
2001-01-01 02:02:02     NULL
211
 
2001-01-01 00:00:00     -25:01:00
212
 
1997-12-31 00:00:00     -25:01:00
213
 
2001-01-01 02:02:02     -24:00:00
214
 
2001-01-01 00:00:00     24:00:00
215
 
NULL    NULL
216
 
NULL    NULL
217
 
2001-01-01 02:02:02     26:02:02
218
 
SELECT TIMEDIFF(t1, t4) As ttt, TIMEDIFF(t2, t3) As qqq,
219
 
TIMEDIFF(t3, t2) As eee, TIMEDIFF(t2, t4) As rrr from test;
220
 
ttt     qqq     eee     rrr
221
 
-744:00:00      NULL    NULL    NULL
222
 
838:59:59       22:58:58        -22:58:58       NULL
223
 
-838:59:59      -22:58:58       22:58:58        NULL
224
 
NULL    26:02:02        -26:02:02       NULL
225
 
00:00:00        -26:02:02       26:02:02        NULL
226
 
NULL    NULL    NULL    NULL
227
 
NULL    NULL    NULL    NULL
228
 
00:00:00        -24:00:00       24:00:00        NULL
229
 
Warnings:
230
 
Warning 1292    Truncated incorrect time value: '26305:01:02'
231
 
Warning 1292    Truncated incorrect time value: '-26305:01:02'
 
145
('2001-01-01 01:01:01', '2001-02-01 01:01:01'),
 
146
('2001-01-01 01:01:01', "1997-12-31 23:59:59.000001"),
 
147
('1997-12-31 23:59:59.000001', '2001-01-01 01:01:01'),
 
148
('2001-01-01 01:01:01', null),
 
149
('2001-01-01 01:01:01', '2001-01-01 01:01:01'),
 
150
('2001-01-01 01:01:01', null),
 
151
(null, null),
 
152
('2001-01-01 01:01:01', '2001-01-01 01:01:01');
232
153
drop table t1, test;
233
 
select addtime("-01:01:01.01", "-23:59:59.1") as a;
234
 
a
235
 
-25:01:00.110000
236
154
select microsecond("1997-12-31 23:59:59.01") as a;
237
155
a
238
156
10000
242
160
select date_add("1997-12-31",INTERVAL "10.09" SECOND_MICROSECOND) as a;
243
161
a
244
162
1997-12-31 00:00:10.090000
245
 
select str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f");
246
 
str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f")
247
 
2003-01-02 10:11:12.001200