← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_sapdb.result

  • Committer: Jay Pipes
  • Date: 2009-02-28 17:49:22 UTC
  • mto: (910.2.6 mordred-noatomics)
  • mto: This revision was merged to the branch mainline in revision 908.
  • Revision ID: jpipes@serialcoder-20090228174922-jczgt4d0662fqmnf
Merging in old r902 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 subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002");
89
 
subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002")
90
 
1997-12-30 22:58:57.999999
91
 
select subtime("1997-12-31 23:59:59.999999", "1998-01-01 01:01:01.999999");
92
 
subtime("1997-12-31 23:59:59.999999", "1998-01-01 01:01:01.999999")
93
 
NULL
94
 
select subtime("01:00:00.999999", "02:00:00.999998");
95
 
subtime("01:00:00.999999", "02:00:00.999998")
96
 
-00:59:59.999999
97
 
select subtime("02:01:01.999999", "01:01:01.999999");
98
 
subtime("02:01:01.999999", "01:01:01.999999")
99
 
01:00:00.000000
100
 
select timestamp("2001-12-01", "01:01:01.999999");
101
 
timestamp("2001-12-01", "01:01:01.999999")
102
 
2001-12-01 01:01:01.999999
103
 
select timestamp("2001-13-01", "01:01:01.000001");
104
 
timestamp("2001-13-01", "01:01:01.000001")
105
 
NULL
106
 
Warnings:
107
 
Warning 1292    Incorrect datetime value: '2001-13-01'
108
 
select timestamp("2001-12-01", "25:01:01");
109
 
timestamp("2001-12-01", "25:01:01")
110
 
2001-12-02 01:01:01
111
88
select timestamp("2001-12-01 01:01:01.000100");
112
89
timestamp("2001-12-01 01:01:01.000100")
113
90
2001-12-01 01:01:01.000100
130
107
1
131
108
create table t1 
132
109
select makedate(1997,1) as f1,
133
 
timestamp(cast("2001-12-01" as date), "01:01:01") as f7,
134
110
date("1997-12-31 23:59:59.000001") as f8;
135
111
describe t1;
136
112
Field   Type    Null    Key     Default Extra
137
113
f1      date    YES             NULL    
138
 
f7      datetime        YES             NULL    
139
114
f8      date    YES             NULL    
140
115
select * from t1;
141
 
f1      f7      f8
142
 
1997-01-01      2001-12-01 01:01:01     1997-12-31
 
116
f1      f8
 
117
1997-01-01      1997-12-31
143
118
create table test(t1 datetime, t4 datetime);
144
119
insert into test values 
145
120
('2001-01-01 01:01:01', '2001-02-01 01:01:01'),