diff options
| author | unknown <hf@deer.(none)> | 2003-06-11 22:07:23 +0500 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2003-06-11 22:07:23 +0500 |
| commit | 4885c3ff9d9c8daa93f5c344b6b61ccf9bcbba28 (patch) | |
| tree | 1cc4ad1493ae45e06385e679a637fa99802c9832 /mysql-test/r/func_time.result | |
| parent | a59410fd68b4b9d859299dd5fcfc5be64a995e22 (diff) | |
| download | mariadb-git-4885c3ff9d9c8daa93f5c344b6b61ccf9bcbba28.tar.gz | |
test case for bug #614
mysql-test/r/func_time.result:
result's checking added
mysql-test/t/func_time.test:
testcase added
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index 2941352c776..06c0be86667 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -329,6 +329,9 @@ insert into t1 values ('2001-01-12 12:23:40'); select ctime, hour(ctime) from t1; ctime hour(ctime) 2001-01-12 12:23:40 12 +select ctime from t1 where extract(MONTH FROM ctime) = 1 AND extract(YEAR FROM ctime) = 2001; +ctime +2001-01-12 12:23:40 drop table t1; create table t1 (id int); create table t2 (id int, date date); |