← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_sapdb.test

  • 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/t/func_sapdb.test
45
45
select makedate(9999,366);
46
46
select makedate(100,1);
47
47
 
48
 
#Time functions
49
 
 
50
 
select subtime("1997-12-31 23:59:59.000001", "1 1:1:1.000002");
51
 
select subtime("1997-12-31 23:59:59.999999", "1998-01-01 01:01:01.999999");
52
 
select subtime("01:00:00.999999", "02:00:00.999998");
53
 
select subtime("02:01:01.999999", "01:01:01.999999");
54
 
 
55
48
# Extraction functions
56
49
 
57
50
# PS doesn't support fractional seconds
58
51
--disable_ps_protocol
59
 
select timestamp("2001-12-01", "01:01:01.999999");
60
 
select timestamp("2001-13-01", "01:01:01.000001");
61
 
select timestamp("2001-12-01", "25:01:01");
62
52
select timestamp("2001-12-01 01:01:01.000100");
63
53
select timestamp("2001-12-01");
64
54
select day("1997-12-31 23:59:59.000001");
69
59
 
70
60
create table t1 
71
61
select makedate(1997,1) as f1,
72
 
   timestamp(cast("2001-12-01" as date), "01:01:01") as f7,
73
62
   date("1997-12-31 23:59:59.000001") as f8;
74
63
describe t1;
75
64
# PS doesn't support fractional seconds