← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_sapdb.result

  • Committer: Brian Aker
  • Date: 2008-11-04 15:39:09 UTC
  • mfrom: (575.1.2 devel)
  • Revision ID: brian@tangent.org-20081104153909-c72hn65udxs1ccal
Merge of Monty's work

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_sapdb.result
59
59
select datediff("1997-11-30 23:59:59.000001","1997-12-31");
60
60
datediff("1997-11-30 23:59:59.000001","1997-12-31")
61
61
-31
62
 
SET @@SQL_MODE="ALLOW_INVALID_DATES";
63
 
select datediff("1997-11-31 23:59:59.000001","1997-12-31");
64
 
datediff("1997-11-31 23:59:59.000001","1997-12-31")
65
 
-30
66
 
SET @@SQL_MODE="";
67
62
select datediff("1997-11-31 23:59:59.000001","1997-12-31");
68
63
datediff("1997-11-31 23:59:59.000001","1997-12-31")
69
64
NULL
194
189
time("1997-12-31 23:59:59.000001") as f9;
195
190
describe t1;
196
191
Field   Type    Null    Key     Default Extra
197
 
f1      date    NO              0000-00-00      
 
192
f1      date    YES             NULL    
198
193
f2      datetime        YES             NULL    
199
194
f3      time    YES             NULL    
200
195
f4      time    YES             NULL