← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • Committer: Stewart Smith
  • Date: 2010-11-03 03:27:09 UTC
  • mto: (1902.1.1 build) (1910.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1903.
  • Revision ID: stewart@flamingspork.com-20101103032709-oyvfrc6eb8fzj0mr
fix docs warning: docs/unlock.rst:2: (WARNING/2) Title underline too short.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_time.result
635
635
from_days(to_days("960101")) as b;
636
636
describe t1;
637
637
Field   Type    Null    Default Default_is_NULL On_Update
638
 
a       DATE    FALSE           FALSE   
639
 
b       DATE    TRUE            TRUE    
 
638
a       DATE    NO              NO      
 
639
b       DATE    YES             YES     
640
640
select * from t1;
641
641
a       b
642
642
2000-02-29      1996-01-01
805
805
'2005.09.01' - INTERVAL 6 MONTH AND t2.day;
806
806
id      day     id      day
807
807
1       2005-06-01      1       2005-08-01
808
 
3       2005-07-01      1       2005-08-01
809
808
1       2005-06-01      2       2005-06-15
810
809
1       2005-06-01      3       2005-07-15
 
810
3       2005-07-01      1       2005-08-01
811
811
3       2005-07-01      3       2005-07-15
812
812
SELECT * FROM t1, t2 
813
813
WHERE CAST(t1.day AS DATE) BETWEEN 
814
814
'2005.09.01' - INTERVAL 6 MONTH AND t2.day;
815
815
id      day     id      day
816
816
1       2005-06-01      1       2005-08-01
817
 
3       2005-07-01      1       2005-08-01
818
817
1       2005-06-01      2       2005-06-15
819
818
1       2005-06-01      3       2005-07-15
 
819
3       2005-07-01      1       2005-08-01
820
820
3       2005-07-01      3       2005-07-15
821
821
DROP TABLE t1,t2;
822
822
create table t1 (field DATE);