diff options
| author | Timothy Smith <timothy.smith@sun.com> | 2009-01-08 03:16:22 +0100 |
|---|---|---|
| committer | Timothy Smith <timothy.smith@sun.com> | 2009-01-08 03:16:22 +0100 |
| commit | 72982373c3a56d56faf060c3c61921d8c2ce11ab (patch) | |
| tree | 682658188747bb8fdad7c32d99eadf03a0832bbd /mysql-test/r/func_time.result | |
| parent | e6100a222d187819d92c63ae5b1e29907ce8f0da (diff) | |
| parent | eb3daa6d75c7c683efcab7164cad2bc20d9fb396 (diff) | |
| download | mariadb-git-72982373c3a56d56faf060c3c61921d8c2ce11ab.tar.gz | |
Auto-merge from upstream 5.1-bugteam
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index cc0fb88b791..b1287a951aa 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -592,6 +592,21 @@ unix_timestamp('1970-01-01 03:00:01') select unix_timestamp('2038-01-19 07:14:07'); unix_timestamp('2038-01-19 07:14:07') 0 +SELECT CHARSET(DAYNAME(19700101)); +CHARSET(DAYNAME(19700101)) +latin1 +SELECT CHARSET(MONTHNAME(19700101)); +CHARSET(MONTHNAME(19700101)) +latin1 +SELECT LOWER(DAYNAME(19700101)); +LOWER(DAYNAME(19700101)) +thursday +SELECT LOWER(MONTHNAME(19700101)); +LOWER(MONTHNAME(19700101)) +january +SELECT COERCIBILITY(MONTHNAME('1970-01-01')),COERCIBILITY(DAYNAME('1970-01-01')); +COERCIBILITY(MONTHNAME('1970-01-01')) COERCIBILITY(DAYNAME('1970-01-01')) +4 4 CREATE TABLE t1 (datetime datetime, timestamp timestamp, date date, time time); INSERT INTO t1 values ("2001-01-02 03:04:05", "2002-01-02 03:04:05", "2003-01-02", "06:07:08"); SELECT * from t1; |