← Back to branch summary

~ubuntu-branches/ubuntu/maverick/drizzle/maverick

« back to all changes in this revision

Viewing changes to tests/r/func_sapdb.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-03-18 12:12:31 UTC
  • Revision ID: james.westby@ubuntu.com-20100318121231-k6g1xe6cshbwa0f8
Tags: upstream-2010.03.1347
Import upstream version 2010.03.1347

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_sapdb.result
 
1
drop table if exists t1, test;
 
2
select extract(DAY_MICROSECOND FROM "1999-01-02 10:11:12.000123");
 
3
extract(DAY_MICROSECOND FROM "1999-01-02 10:11:12.000123")
 
4
2101112000123
 
5
select extract(HOUR_MICROSECOND FROM "1999-01-02 10:11:12.000123");
 
6
extract(HOUR_MICROSECOND FROM "1999-01-02 10:11:12.000123")
 
7
101112000123
 
8
select extract(MINUTE_MICROSECOND FROM "1999-01-02 10:11:12.000123");
 
9
extract(MINUTE_MICROSECOND FROM "1999-01-02 10:11:12.000123")
 
10
1112000123
 
11
select extract(SECOND_MICROSECOND FROM "1999-01-02 10:11:12.000123");
 
12
extract(SECOND_MICROSECOND FROM "1999-01-02 10:11:12.000123")
 
13
12000123
 
14
select extract(MICROSECOND FROM "1999-01-02 10:11:12.000123");
 
15
extract(MICROSECOND FROM "1999-01-02 10:11:12.000123")
 
16
123
 
17
select date_format("1997-12-31 23:59:59.000002", "%f");
 
18
date_format("1997-12-31 23:59:59.000002", "%f")
 
19
000002
 
20
select date_add("1997-12-31 23:59:59.000002",INTERVAL "10000 99:99:99.999999" DAY_MICROSECOND);
 
21
date_add("1997-12-31 23:59:59.000002",INTERVAL "10000 99:99:99.999999" DAY_MICROSECOND)
 
22
2025-05-23 04:40:39.000001
 
23
select date_add("1997-12-31 23:59:59.000002",INTERVAL "10000:99:99.999999" HOUR_MICROSECOND);
 
24
date_add("1997-12-31 23:59:59.000002",INTERVAL "10000:99:99.999999" HOUR_MICROSECOND)
 
25
1999-02-21 17:40:39.000001
 
26
select date_add("1997-12-31 23:59:59.000002",INTERVAL "10000:99.999999" MINUTE_MICROSECOND);
 
27
date_add("1997-12-31 23:59:59.000002",INTERVAL "10000:99.999999" MINUTE_MICROSECOND)
 
28
1998-01-07 22:41:39.000001
 
29
select date_add("1997-12-31 23:59:59.000002",INTERVAL "10000.999999" SECOND_MICROSECOND);
 
30
date_add("1997-12-31 23:59:59.000002",INTERVAL "10000.999999" SECOND_MICROSECOND)
 
31
1998-01-01 02:46:40.000001
 
32
select date_add("1997-12-31 23:59:59.000002",INTERVAL "999999" MICROSECOND);
 
33
date_add("1997-12-31 23:59:59.000002",INTERVAL "999999" MICROSECOND)
 
34
1998-01-01 00:00:00.000001
 
35
select date_sub("1998-01-01 00:00:00.000001",INTERVAL "1 1:1:1.000002" DAY_MICROSECOND);
 
36
date_sub("1998-01-01 00:00:00.000001",INTERVAL "1 1:1:1.000002" DAY_MICROSECOND)
 
37
1997-12-30 22:58:58.999999
 
38
select date_sub("1998-01-01 00:00:00.000001",INTERVAL "1:1:1.000002" HOUR_MICROSECOND);
 
39
date_sub("1998-01-01 00:00:00.000001",INTERVAL "1:1:1.000002" HOUR_MICROSECOND)
 
40
1997-12-31 22:58:58.999999
 
41
select date_sub("1998-01-01 00:00:00.000001",INTERVAL "1:1.000002" MINUTE_MICROSECOND);
 
42
date_sub("1998-01-01 00:00:00.000001",INTERVAL "1:1.000002" MINUTE_MICROSECOND)
 
43
1997-12-31 23:58:58.999999
 
44
select date_sub("1998-01-01 00:00:00.000001",INTERVAL "1.000002" SECOND_MICROSECOND);
 
45
date_sub("1998-01-01 00:00:00.000001",INTERVAL "1.000002" SECOND_MICROSECOND)
 
46
1997-12-31 23:59:58.999999
 
47
select date_sub("1998-01-01 00:00:00.000001",INTERVAL "000002" MICROSECOND);
 
48
date_sub("1998-01-01 00:00:00.000001",INTERVAL "000002" MICROSECOND)
 
49
1997-12-31 23:59:59.999999
 
50
select adddate("1997-12-31 23:59:59.000001", 10);
 
51
adddate("1997-12-31 23:59:59.000001", 10)
 
52
1998-01-10 23:59:59.000001
 
53
select subdate("1997-12-31 23:59:59.000001", 10);
 
54
subdate("1997-12-31 23:59:59.000001", 10)
 
55
1997-12-21 23:59:59.000001
 
56
select datediff("1997-12-31 23:59:59.000001","1997-12-30");
 
57
datediff("1997-12-31 23:59:59.000001","1997-12-30")
 
58
1
 
59
select datediff("1997-11-30 23:59:59.000001","1997-12-31");
 
60
datediff("1997-11-30 23:59:59.000001","1997-12-31")
 
61
-31
 
62
select datediff("1997-11-31 23:59:59.000001","1997-12-31");
 
63
ERROR HY000: Received an invalid datetime value '1997-11-31 23:59:59.000001'.
 
64
select datediff("1997-11-30 23:59:59.000001",null);
 
65
datediff("1997-11-30 23:59:59.000001",null)
 
66
NULL
 
67
select makedate(03,1);
 
68
makedate(03,1)
 
69
2003-01-01
 
70
select makedate('0003',1);
 
71
makedate('0003',1)
 
72
2003-01-01
 
73
select makedate(1997,1);
 
74
makedate(1997,1)
 
75
1997-01-01
 
76
select makedate(1997,0);
 
77
makedate(1997,0)
 
78
NULL
 
79
select makedate(9999,365);
 
80
makedate(9999,365)
 
81
9999-12-31
 
82
select makedate(9999,366);
 
83
makedate(9999,366)
 
84
NULL
 
85
select makedate(100,1);
 
86
makedate(100,1)
 
87
0100-01-01
 
88
select timestamp("2001-12-01 01:01:01.000100");
 
89
timestamp("2001-12-01 01:01:01.000100")
 
90
2001-12-01 01:01:01.000100
 
91
select timestamp("2001-12-01");
 
92
timestamp("2001-12-01")
 
93
2001-12-01 00:00:00
 
94
select day("1997-12-31 23:59:59.000001");
 
95
day("1997-12-31 23:59:59.000001")
 
96
31
 
97
select date("1997-12-31 23:59:59.000001");
 
98
date("1997-12-31 23:59:59.000001")
 
99
1997-12-31
 
100
select date("1997-13-31 23:59:59.000001");
 
101
date("1997-13-31 23:59:59.000001")
 
102
NULL
 
103
Warnings:
 
104
Warning 1292    Incorrect datetime value: '1997-13-31 23:59:59.000001'
 
105
select microsecond("1997-12-31 23:59:59.000001");
 
106
microsecond("1997-12-31 23:59:59.000001")
 
107
1
 
108
create table t1 
 
109
select makedate(1997,1) as f1,
 
110
date("1997-12-31 23:59:59.000001") as f8;
 
111
describe t1;
 
112
Field   Type    Null    Default Default_is_NULL On_Update
 
113
f1      DATE    TRUE            TRUE    
 
114
f8      DATE    TRUE            TRUE    
 
115
select * from t1;
 
116
f1      f8
 
117
1997-01-01      1997-12-31
 
118
create table test(t1 datetime, t4 datetime);
 
119
insert into test values 
 
120
('2001-01-01 01:01:01', '2001-02-01 01:01:01'),
 
121
('2001-01-01 01:01:01', "1997-12-31 23:59:59.000001"),
 
122
('1997-12-31 23:59:59.000001', '2001-01-01 01:01:01'),
 
123
('2001-01-01 01:01:01', null),
 
124
('2001-01-01 01:01:01', '2001-01-01 01:01:01'),
 
125
('2001-01-01 01:01:01', null),
 
126
(null, null),
 
127
('2001-01-01 01:01:01', '2001-01-01 01:01:01');
 
128
drop table t1, test;
 
129
select microsecond("1997-12-31 23:59:59.01") as a;
 
130
a
 
131
10000
 
132
select microsecond(19971231235959.01) as a;
 
133
a
 
134
10000
 
135
select date_add("1997-12-31",INTERVAL "10.09" SECOND_MICROSECOND) as a;
 
136
a
 
137
1997-12-31 00:00:10.090000