← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_time.result

  • Committer: Andrew Hutchings
  • Date: 2010-09-08 19:03:09 UTC
  • mfrom: (1750 staging)
  • mto: (1750.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1751.
  • Revision ID: andrew@linuxjedi.co.uk-20100908190309-mya1nu7xvo1fpvk8
Merge trunk into branch

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_time.result
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);