~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/year.test

  • Committer: Brian Aker
  • Date: 2009-01-28 20:21:13 UTC
  • mfrom: (813.1.11 new-temporal)
  • Revision ID: brian@tangent.org-20090128202113-q1zkkhlzpgwvfbb2
Merge from Jay.

Show diffs side-by-side

added added

removed removed

Lines of Context:
71
71
SELECT YEAR('07/31/2009');
72
72
 
73
73
74
 
# The following tests should produce errors for YEAR().    
75
 
76
 
 
77
 
#
78
 
# Test boundary dates for YEAR 
79
 
#
80
 
 
81
 
82
74
# Tests for alternate DATETIME syntaxes 
83
75
# in string and numeric formats. All should
84
76
# return 2009.
113
105
, blob_fld BLOB NOT NULL
114
106
);
115
107
 
 
108
# Should all output 2007
116
109
INSERT INTO t1 VALUES (
117
110
20071130
118
111
, "2007-11-30"