diff options
| author | monty@hundin.mysql.fi <> | 2002-03-07 00:21:37 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-03-07 00:21:37 +0200 |
| commit | 771e66873206b809800a65ecab06b5e0130e67b8 (patch) | |
| tree | 5afa53c5d3ff2124211ff8d7d325d1d74022bfd2 /mysql-test/r | |
| parent | e9ba8d58feb15dba676e5603f9c4134f1d411c79 (diff) | |
| download | mariadb-git-771e66873206b809800a65ecab06b5e0130e67b8.tar.gz | |
Update test results
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/type_date.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/type_date.result b/mysql-test/r/type_date.result index 642a8a7004d..214328eab47 100644 --- a/mysql-test/r/type_date.result +++ b/mysql-test/r/type_date.result @@ -59,3 +59,15 @@ date_add(date,INTERVAL 1 DAY) date_add(date,INTERVAL 1 SECOND) 2000-08-11 2000-08-10 00:00:01 2000-08-12 2000-08-11 00:00:01 drop table t1; +CREATE TABLE t1(AFIELD INT); +INSERT INTO t1 VALUES(1); +CREATE TABLE t2(GMT VARCHAR(32)); +INSERT INTO t2 VALUES('GMT-0800'); +SELECT DATE_FORMAT("2002-03-06 10:11:12", CONCAT('%a, %d %M %Y %H:%i:%s ' , t2.GMT)) FROM t1, t2 GROUP BY t1.AFIELD; +DATE_FORMAT("2002-03-06 10:11:12", CONCAT('%a, %d %M %Y %H:%i:%s ' , t2.GMT)) +Wed, 06 March 2002 10:11:12 GMT-0800 +INSERT INTO t1 VALUES(1); +SELECT DATE_FORMAT("2002-03-06 10:11:12", CONCAT('%a, %d %M %Y %H:%i:%s ' , t2.GMT)), DATE_FORMAT("2002-03-06 10:11:12", CONCAT('%a, %d %M %Y %H:%i:%s ' , t2.GMT)) FROM t1,t2 GROUP BY t1.AFIELD; +DATE_FORMAT("2002-03-06 10:11:12", CONCAT('%a, %d %M %Y %H:%i:%s ' , t2.GMT)) DATE_FORMAT("2002-03-06 10:11:12", CONCAT('%a, %d %M %Y %H:%i:%s ' , t2.GMT)) +Wed, 06 March 2002 10:11:12 GMT-0800 Wed, 06 March 2002 10:11:12 GMT-0800 +drop table t1,t2; |