summaryrefslogtreecommitdiff
path: root/mysql-test/r/date_formats.result
diff options
context:
space:
mode:
authorunknown <ramil/ram@mysql.com/myoffice.izhnet.ru>2006-07-23 13:43:44 +0500
committerunknown <ramil/ram@mysql.com/myoffice.izhnet.ru>2006-07-23 13:43:44 +0500
commit8819a677cc9872a9f9ecda4a806f3d2bcdf98a7d (patch)
treeab23512d6e8f526645eb8c22908190e9c563fd4b /mysql-test/r/date_formats.result
parent7c7949b05b8e5482bae6967f5bf2de78934dbbef (diff)
parent97a3d52682e9e92d2526b5260521d3a35bdce311 (diff)
downloadmariadb-git-8819a677cc9872a9f9ecda4a806f3d2bcdf98a7d.tar.gz
Merge rkalimullin@bk-internal.mysql.com:/home/bk/mysql-5.0-maint
into mysql.com:/usr/home/ram/work/5.0.b19370 mysql-test/r/date_formats.result: Auto merged
Diffstat (limited to 'mysql-test/r/date_formats.result')
-rw-r--r--mysql-test/r/date_formats.result4
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/r/date_formats.result b/mysql-test/r/date_formats.result
index 08ed5fc6439..bbe3aee1fb0 100644
--- a/mysql-test/r/date_formats.result
+++ b/mysql-test/r/date_formats.result
@@ -449,6 +449,8 @@ create table t1 select str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%
str_to_date("10:11:12.0012", "%H:%i:%S.%f") as f2,
str_to_date("2003-01-02", "%Y-%m-%d") as f3,
str_to_date("02", "%d") as f4, str_to_date("02 10", "%d %H") as f5;
+Warnings:
+Warning 1265 Data truncated for column 'f4' at row 1
describe t1;
Field Type Null Key Default Extra
f1 datetime YES NULL
@@ -458,7 +460,7 @@ f4 date YES NULL
f5 time YES NULL
select * from t1;
f1 f2 f3 f4 f5
-2003-01-02 10:11:12 10:11:12 2003-01-02 0000-00-02 58:00:00
+2003-01-02 10:11:12 10:11:12 2003-01-02 0000-00-00 58:00:00
drop table t1;
create table t1 select "02 10" as a, "%d %H" as b;
select str_to_date(a,b) from t1;