| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/MariaDB/mysql-test/main/ (MariaDB Server Version 8.1-8.4©) Datei vom 1.9.2026 mit Größe 34 kB |
|
Quelle date_formats.result Sprache: Lisp |
|||||||||||||||
|
select str_to_date(concat('15-01-2001',' 2:59:58.999'), concat('%d-%m-%Y',' ','%H:%i:%s.%f')) as exp; exp 2001-01-15 02:59:58.999000 select STR_TO_DATE('2004.12.12 22.30.61','%Y.%m.%d %T') as exp; exp NULL Warnings: Warning 1411 Incorrect time value: '22.30.61' for function str_to_date create table t1 (date char(30), format char(30) not null); insert into t1 values ('2003-01-02 10:11:12', '%Y-%m-%d %H:%i:%S'), ('03-01-02 8:11:2.123456', '%y-%m-%d %H:%i:%S.%#'), ('0003-01-02 8:11:2.123456', '%Y-%m-%d %H:%i:%S.%#'), ('03-01-02 8:11:2.123456', '%Y-%m-%d %H:%i:%S.%#'), ('2003-01-02 10:11:12 PM', '%Y-%m-%d %h:%i:%S %p'), ('2003-01-02 01:11:12.12345AM', '%Y-%m-%d %h:%i:%S.%f%p'), ('2003-01-02 02:11:12.12345AM', '%Y-%m-%d %h:%i:%S.%f %p'), ('2003-01-02 12:11:12.12345 am', '%Y-%m-%d %h:%i:%S.%f%p'), ('2003-01-02 11:11:12Pm', '%Y-%m-%d %h:%i:%S%p'), ('10:20:10', '%H:%i:%s'), ('10:20:10', '%h:%i:%s.%f'), ('10:20:10', '%T'), ('10:20:10AM', '%h:%i:%s%p'), ('10:20:10AM', '%r'), ('10:20:10.44AM', '%h:%i:%s.%f%p'), ('15-01-2001 12:59:58', '%d-%m-%Y %H:%i:%S'), ('15 September 2001', '%d %M %Y'), ('15 SEPTEMB 2001', '%d %M %Y'), ('15 MAY 2001', '%d %b %Y'), ('15th May 2001', '%D %b %Y'), ('Sunday 15 MAY 2001', '%W %d %b %Y'), ('Sund 15 MAY 2001', '%W %d %b %Y'), ('Tuesday 00 2002', '%W %U %Y'), ('Thursday 53 1998', '%W %u %Y'), ('Sunday 01 2001', '%W %v %x'), ('Tuesday 52 2001', '%W %V %X'), ('060 2004', '%j %Y'), ('4 53 1998', '%w %u %Y'), ('15-01-2001', '%d-%m-%Y %H:%i:%S'), ('15-01-20', '%d-%m-%y'), ('15-2001-1', '%d-%Y-%c'); select date,format,str_to_date(date, format) as str_to_date from t1; date format str_to_date 2003-01-02 10:11:12 %Y-%m-%d %H:%i:%S 2003-01-02 10:11:12.000000 03-01-02 8:11:2.123456 %y-%m-%d %H:%i:%S.%# 2003-01-02 08:11:02.000000 0003-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 0003-01-02 08:11:02.000000 03-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 2003-01-02 08:11:02.000000 2003-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 2003-01-02 22:11:12.000000 2003-01-02 01:11:12.12345AM %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 01:11:12.123450 2003-01-02 02:11:12.12345AM %Y-%m-%d %h:%i:%S.%f %p 2003-01-02 02:11:12.123450 2003-01-02 12:11:12.12345 am %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 00:11:12.123450 2003-01-02 11:11:12Pm %Y-%m-%d %h:%i:%S%p 2003-01-02 23:11:12.000000 10:20:10 %H:%i:%s 0000-00-00 10:20:10.000000 10:20:10 %h:%i:%s.%f 0000-00-00 10:20:10.000000 10:20:10 %T 0000-00-00 10:20:10.000000 10:20:10AM %h:%i:%s%p 0000-00-00 10:20:10.000000 10:20:10AM %r 0000-00-00 10:20:10.000000 10:20:10.44AM %h:%i:%s.%f%p 0000-00-00 10:20:10.440000 15-01-2001 12:59:58 %d-%m-%Y %H:%i:%S 2001-01-15 12:59:58.000000 15 September 2001 %d %M %Y 2001-09-15 00:00:00.000000 15 SEPTEMB 2001 %d %M %Y 2001-09-15 00:00:00.000000 15 MAY 2001 %d %b %Y 2001-05-15 00:00:00.000000 15th May 2001 %D %b %Y 2001-05-15 00:00:00.000000 Sunday 15 MAY 2001 %W %d %b %Y 2001-05-15 00:00:00.000000 Sund 15 MAY 2001 %W %d %b %Y 2001-05-15 00:00:00.000000 Tuesday 00 2002 %W %U %Y 2002-01-01 00:00:00.000000 Thursday 53 1998 %W %u %Y 1998-12-31 00:00:00.000000 Sunday 01 2001 %W %v %x 2001-01-07 00:00:00.000000 Tuesday 52 2001 %W %V %X 2002-01-01 00:00:00.000000 060 2004 %j %Y 2004-02-29 00:00:00.000000 4 53 1998 %w %u %Y 1998-12-31 00:00:00.000000 15-01-2001 %d-%m-%Y %H:%i:%S 2001-01-15 00:00:00.000000 15-01-20 %d-%m-%y 2020-01-15 00:00:00.000000 15-2001-1 %d-%Y-%c 2001-01-15 00:00:00.000000 select date,format,concat('',str_to_date(date, format)) as con from t1; date format con 2003-01-02 10:11:12 %Y-%m-%d %H:%i:%S 2003-01-02 10:11:12.000000 03-01-02 8:11:2.123456 %y-%m-%d %H:%i:%S.%# 2003-01-02 08:11:02.000000 0003-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 0003-01-02 08:11:02.000000 03-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 2003-01-02 08:11:02.000000 2003-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 2003-01-02 22:11:12.000000 2003-01-02 01:11:12.12345AM %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 01:11:12.123450 2003-01-02 02:11:12.12345AM %Y-%m-%d %h:%i:%S.%f %p 2003-01-02 02:11:12.123450 2003-01-02 12:11:12.12345 am %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 00:11:12.123450 2003-01-02 11:11:12Pm %Y-%m-%d %h:%i:%S%p 2003-01-02 23:11:12.000000 10:20:10 %H:%i:%s 0000-00-00 10:20:10.000000 10:20:10 %h:%i:%s.%f 0000-00-00 10:20:10.000000 10:20:10 %T 0000-00-00 10:20:10.000000 10:20:10AM %h:%i:%s%p 0000-00-00 10:20:10.000000 10:20:10AM %r 0000-00-00 10:20:10.000000 10:20:10.44AM %h:%i:%s.%f%p 0000-00-00 10:20:10.440000 15-01-2001 12:59:58 %d-%m-%Y %H:%i:%S 2001-01-15 12:59:58.000000 15 September 2001 %d %M %Y 2001-09-15 00:00:00.000000 15 SEPTEMB 2001 %d %M %Y 2001-09-15 00:00:00.000000 15 MAY 2001 %d %b %Y 2001-05-15 00:00:00.000000 15th May 2001 %D %b %Y 2001-05-15 00:00:00.000000 Sunday 15 MAY 2001 %W %d %b %Y 2001-05-15 00:00:00.000000 Sund 15 MAY 2001 %W %d %b %Y 2001-05-15 00:00:00.000000 Tuesday 00 2002 %W %U %Y 2002-01-01 00:00:00.000000 Thursday 53 1998 %W %u %Y 1998-12-31 00:00:00.000000 Sunday 01 2001 %W %v %x 2001-01-07 00:00:00.000000 Tuesday 52 2001 %W %V %X 2002-01-01 00:00:00.000000 060 2004 %j %Y 2004-02-29 00:00:00.000000 4 53 1998 %w %u %Y 1998-12-31 00:00:00.000000 15-01-2001 %d-%m-%Y %H:%i:%S 2001-01-15 00:00:00.000000 15-01-20 %d-%m-%y 2020-01-15 00:00:00.000000 15-2001-1 %d-%Y-%c 2001-01-15 00:00:00.000000 select date,format,cast(str_to_date(date, format) as datetime) as datetime from t1; date format datetime 2003-01-02 10:11:12 %Y-%m-%d %H:%i:%S 2003-01-02 10:11:12 03-01-02 8:11:2.123456 %y-%m-%d %H:%i:%S.%# 2003-01-02 08:11:02 0003-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 0003-01-02 08:11:02 03-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 2003-01-02 08:11:02 2003-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 2003-01-02 22:11:12 2003-01-02 01:11:12.12345AM %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 01:11:12 2003-01-02 02:11:12.12345AM %Y-%m-%d %h:%i:%S.%f %p 2003-01-02 02:11:12 2003-01-02 12:11:12.12345 am %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 00:11:12 2003-01-02 11:11:12Pm %Y-%m-%d %h:%i:%S%p 2003-01-02 23:11:12 10:20:10 %H:%i:%s 0000-00-00 10:20:10 10:20:10 %h:%i:%s.%f 0000-00-00 10:20:10 10:20:10 %T 0000-00-00 10:20:10 10:20:10AM %h:%i:%s%p 0000-00-00 10:20:10 10:20:10AM %r 0000-00-00 10:20:10 10:20:10.44AM %h:%i:%s.%f%p 0000-00-00 10:20:10 15-01-2001 12:59:58 %d-%m-%Y %H:%i:%S 2001-01-15 12:59:58 15 September 2001 %d %M %Y 2001-09-15 00:00:00 15 SEPTEMB 2001 %d %M %Y 2001-09-15 00:00:00 15 MAY 2001 %d %b %Y 2001-05-15 00:00:00 15th May 2001 %D %b %Y 2001-05-15 00:00:00 Sunday 15 MAY 2001 %W %d %b %Y 2001-05-15 00:00:00 Sund 15 MAY 2001 %W %d %b %Y 2001-05-15 00:00:00 Tuesday 00 2002 %W %U %Y 2002-01-01 00:00:00 Thursday 53 1998 %W %u %Y 1998-12-31 00:00:00 Sunday 01 2001 %W %v %x 2001-01-07 00:00:00 Tuesday 52 2001 %W %V %X 2002-01-01 00:00:00 060 2004 %j %Y 2004-02-29 00:00:00 4 53 1998 %w %u %Y 1998-12-31 00:00:00 15-01-2001 %d-%m-%Y %H:%i:%S 2001-01-15 00:00:00 15-01-20 %d-%m-%y 2020-01-15 00:00:00 15-2001-1 %d-%Y-%c 2001-01-15 00:00:00 select date,format,DATE(str_to_date(date, format)) as date2 from t1; date format date2 2003-01-02 10:11:12 %Y-%m-%d %H:%i:%S 2003-01-02 03-01-02 8:11:2.123456 %y-%m-%d %H:%i:%S.%# 2003-01-02 0003-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 0003-01-02 03-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 2003-01-02 2003-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 2003-01-02 2003-01-02 01:11:12.12345AM %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 2003-01-02 02:11:12.12345AM %Y-%m-%d %h:%i:%S.%f %p 2003-01-02 2003-01-02 12:11:12.12345 am %Y-%m-%d %h:%i:%S.%f%p 2003-01-02 2003-01-02 11:11:12Pm %Y-%m-%d %h:%i:%S%p 2003-01-02 10:20:10 %H:%i:%s 0000-00-00 10:20:10 %h:%i:%s.%f 0000-00-00 10:20:10 %T 0000-00-00 10:20:10AM %h:%i:%s%p 0000-00-00 10:20:10AM %r 0000-00-00 10:20:10.44AM %h:%i:%s.%f%p 0000-00-00 15-01-2001 12:59:58 %d-%m-%Y %H:%i:%S 2001-01-15 15 September 2001 %d %M %Y 2001-09-15 15 SEPTEMB 2001 %d %M %Y 2001-09-15 15 MAY 2001 %d %b %Y 2001-05-15 15th May 2001 %D %b %Y 2001-05-15 Sunday 15 MAY 2001 %W %d %b %Y 2001-05-15 Sund 15 MAY 2001 %W %d %b %Y 2001-05-15 Tuesday 00 2002 %W %U %Y 2002-01-01 Thursday 53 1998 %W %u %Y 1998-12-31 Sunday 01 2001 %W %v %x 2001-01-07 Tuesday 52 2001 %W %V %X 2002-01-01 060 2004 %j %Y 2004-02-29 4 53 1998 %w %u %Y 1998-12-31 15-01-2001 %d-%m-%Y %H:%i:%S 2001-01-15 15-01-20 %d-%m-%y 2020-01-15 15-2001-1 %d-%Y-%c 2001-01-15 select date,format,TIME(str_to_date(date, format)) as time from t1; date format time 2003-01-02 10:11:12 %Y-%m-%d %H:%i:%S 10:11:12.000000 03-01-02 8:11:2.123456 %y-%m-%d %H:%i:%S.%# 08:11:02.000000 0003-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 08:11:02.000000 03-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 08:11:02.000000 2003-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 22:11:12.000000 2003-01-02 01:11:12.12345AM %Y-%m-%d %h:%i:%S.%f%p 01:11:12.123450 2003-01-02 02:11:12.12345AM %Y-%m-%d %h:%i:%S.%f %p 02:11:12.123450 2003-01-02 12:11:12.12345 am %Y-%m-%d %h:%i:%S.%f%p 00:11:12.123450 2003-01-02 11:11:12Pm %Y-%m-%d %h:%i:%S%p 23:11:12.000000 10:20:10 %H:%i:%s 10:20:10.000000 10:20:10 %h:%i:%s.%f 10:20:10.000000 10:20:10 %T 10:20:10.000000 10:20:10AM %h:%i:%s%p 10:20:10.000000 10:20:10AM %r 10:20:10.000000 10:20:10.44AM %h:%i:%s.%f%p 10:20:10.440000 15-01-2001 12:59:58 %d-%m-%Y %H:%i:%S 12:59:58.000000 15 September 2001 %d %M %Y 00:00:00.000000 15 SEPTEMB 2001 %d %M %Y 00:00:00.000000 15 MAY 2001 %d %b %Y 00:00:00.000000 15th May 2001 %D %b %Y 00:00:00.000000 Sunday 15 MAY 2001 %W %d %b %Y 00:00:00.000000 Sund 15 MAY 2001 %W %d %b %Y 00:00:00.000000 Tuesday 00 2002 %W %U %Y 00:00:00.000000 Thursday 53 1998 %W %u %Y 00:00:00.000000 Sunday 01 2001 %W %v %x 00:00:00.000000 Tuesday 52 2001 %W %V %X 00:00:00.000000 060 2004 %j %Y 00:00:00.000000 4 53 1998 %w %u %Y 00:00:00.000000 15-01-2001 %d-%m-%Y %H:%i:%S 00:00:00.000000 15-01-20 %d-%m-%y 00:00:00.000000 15-2001-1 %d-%Y-%c 00:00:00.000000 select date,format,concat(TIME(str_to_date(date, format))) as time2 from t1; date format time2 2003-01-02 10:11:12 %Y-%m-%d %H:%i:%S 10:11:12.000000 03-01-02 8:11:2.123456 %y-%m-%d %H:%i:%S.%# 08:11:02.000000 0003-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 08:11:02.000000 03-01-02 8:11:2.123456 %Y-%m-%d %H:%i:%S.%# 08:11:02.000000 2003-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 22:11:12.000000 2003-01-02 01:11:12.12345AM %Y-%m-%d %h:%i:%S.%f%p 01:11:12.123450 2003-01-02 02:11:12.12345AM %Y-%m-%d %h:%i:%S.%f %p 02:11:12.123450 2003-01-02 12:11:12.12345 am %Y-%m-%d %h:%i:%S.%f%p 00:11:12.123450 2003-01-02 11:11:12Pm %Y-%m-%d %h:%i:%S%p 23:11:12.000000 10:20:10 %H:%i:%s 10:20:10.000000 10:20:10 %h:%i:%s.%f 10:20:10.000000 10:20:10 %T 10:20:10.000000 10:20:10AM %h:%i:%s%p 10:20:10.000000 10:20:10AM %r 10:20:10.000000 10:20:10.44AM %h:%i:%s.%f%p 10:20:10.440000 15-01-2001 12:59:58 %d-%m-%Y %H:%i:%S 12:59:58.000000 15 September 2001 %d %M %Y 00:00:00.000000 15 SEPTEMB 2001 %d %M %Y 00:00:00.000000 15 MAY 2001 %d %b %Y 00:00:00.000000 15th May 2001 %D %b %Y 00:00:00.000000 Sunday 15 MAY 2001 %W %d %b %Y 00:00:00.000000 Sund 15 MAY 2001 %W %d %b %Y 00:00:00.000000 Tuesday 00 2002 %W %U %Y 00:00:00.000000 Thursday 53 1998 %W %u %Y 00:00:00.000000 Sunday 01 2001 %W %v %x 00:00:00.000000 Tuesday 52 2001 %W %V %X 00:00:00.000000 060 2004 %j %Y 00:00:00.000000 4 53 1998 %w %u %Y 00:00:00.000000 15-01-2001 %d-%m-%Y %H:%i:%S 00:00:00.000000 15-01-20 %d-%m-%y 00:00:00.000000 15-2001-1 %d-%Y-%c 00:00:00.000000 select concat('',str_to_date('8:11:2.123456 03-01-02','%H:%i:%S.%f %y-%m-%d')) as exp exp 2003-01-02 08:11:02.123456 truncate table t1; insert into t1 values ('2003-01-02 10:11:12 PM', '%Y-%m-%d %H:%i:%S %p'), ('2003-01-02 10:11:12.123456', '%Y-%m-%d %h:%i:%S %p'), ('2003-01-02 10:11:12AM', '%Y-%m-%d %h:%i:%S.%f %p'), ('2003-01-02 10:11:12AN', '%Y-%m-%d %h:%i:%S%p'), ('2003-01-02 10:11:12 PM', '%y-%m-%d %H:%i:%S %p'), ('10:20:10AM', '%H:%i:%s%p'), ('15 Septembei 2001', '%d %M %Y'), ('15 Ju 2001', '%d %M %Y'), ('Sund 15 MA', '%W %d %b %Y'), ('Thursdai 12 1998', '%W %u %Y'), ('Sunday 01 2001', '%W %v %X'), ('Tuesday 52 2001', '%W %V %x'), ('Tuesday 52 2001', '%W %V %Y'), ('Tuesday 52 2001', '%W %u %x'), ('7 53 1998', '%w %u %Y'), (NULL, get_format(DATE,'USA')); select date,format,str_to_date(date, format) as str_to_date from t1; date format str_to_date 2003-01-02 10:11:12 PM %Y-%m-%d %H:%i:%S %p NULL 2003-01-02 10:11:12.123456 %Y-%m-%d %h:%i:%S %p NULL 2003-01-02 10:11:12AM %Y-%m-%d %h:%i:%S.%f %p NULL 2003-01-02 10:11:12AN %Y-%m-%d %h:%i:%S%p NULL 2003-01-02 10:11:12 PM %y-%m-%d %H:%i:%S %p NULL 10:20:10AM %H:%i:%s%p NULL 15 Septembei 2001 %d %M %Y NULL 15 Ju 2001 %d %M %Y NULL Sund 15 MA %W %d %b %Y NULL Thursdai 12 1998 %W %u %Y NULL Sunday 01 2001 %W %v %X NULL Tuesday 52 2001 %W %V %x NULL Tuesday 52 2001 %W %V %Y NULL Tuesday 52 2001 %W %u %x NULL 7 53 1998 %w %u %Y NULL NULL %m.%d.%Y NULL Warnings: Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12 PM' for function str_to_date Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12.123456' for function str_to_d Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12AM' for function str_to_date Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12AN' for function str_to_date Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12 PM' for function str_to_date Warning 1411 Incorrect datetime value: '10:20:10AM' for function str_to_date Warning 1411 Incorrect datetime value: '15 Septembei 2001' for function str_to_date Warning 1411 Incorrect datetime value: '15 Ju 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Sund 15 MA' for function str_to_date Warning 1411 Incorrect datetime value: 'Thursdai 12 1998' for function str_to_date Warning 1411 Incorrect datetime value: 'Sunday 01 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Tuesday 52 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Tuesday 52 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Tuesday 52 2001' for function str_to_date Warning 1411 Incorrect datetime value: '7 53 1998' for function str_to_date select date,format,concat(str_to_date(date, format),'') as con from t1; date format con 2003-01-02 10:11:12 PM %Y-%m-%d %H:%i:%S %p NULL 2003-01-02 10:11:12.123456 %Y-%m-%d %h:%i:%S %p NULL 2003-01-02 10:11:12AM %Y-%m-%d %h:%i:%S.%f %p NULL 2003-01-02 10:11:12AN %Y-%m-%d %h:%i:%S%p NULL 2003-01-02 10:11:12 PM %y-%m-%d %H:%i:%S %p NULL 10:20:10AM %H:%i:%s%p NULL 15 Septembei 2001 %d %M %Y NULL 15 Ju 2001 %d %M %Y NULL Sund 15 MA %W %d %b %Y NULL Thursdai 12 1998 %W %u %Y NULL Sunday 01 2001 %W %v %X NULL Tuesday 52 2001 %W %V %x NULL Tuesday 52 2001 %W %V %Y NULL Tuesday 52 2001 %W %u %x NULL 7 53 1998 %w %u %Y NULL NULL %m.%d.%Y NULL Warnings: Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12 PM' for function str_to_date Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12.123456' for function str_to_d Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12AM' for function str_to_date Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12AN' for function str_to_date Warning 1411 Incorrect datetime value: '2003-01-02 10:11:12 PM' for function str_to_date Warning 1411 Incorrect datetime value: '10:20:10AM' for function str_to_date Warning 1411 Incorrect datetime value: '15 Septembei 2001' for function str_to_date Warning 1411 Incorrect datetime value: '15 Ju 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Sund 15 MA' for function str_to_date Warning 1411 Incorrect datetime value: 'Thursdai 12 1998' for function str_to_date Warning 1411 Incorrect datetime value: 'Sunday 01 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Tuesday 52 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Tuesday 52 2001' for function str_to_date Warning 1411 Incorrect datetime value: 'Tuesday 52 2001' for function str_to_date Warning 1411 Incorrect datetime value: '7 53 1998' for function str_to_date truncate table t1; insert into t1 values ('10:20:10AM', '%h:%i:%s'), ('2003-01-02 10:11:12', '%Y-%m-%d %h:%i:%S'), ('03-01-02 10:11:12 PM', '%Y-%m-%d %h:%i:%S %p'); select date,format,str_to_date(date, format) as str_to_date from t1; date format str_to_date 10:20:10AM %h:%i:%s 0000-00-00 10:20:10.000000 2003-01-02 10:11:12 %Y-%m-%d %h:%i:%S 2003-01-02 10:11:12.000000 03-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 2003-01-02 22:11:12.000000 Warnings: Warning 1292 Truncated incorrect datetime value: '10:20:10AM' select date,format,concat(str_to_date(date, format),'') as con from t1; date format con 10:20:10AM %h:%i:%s 0000-00-00 10:20:10.000000 2003-01-02 10:11:12 %Y-%m-%d %h:%i:%S 2003-01-02 10:11:12.000000 03-01-02 10:11:12 PM %Y-%m-%d %h:%i:%S %p 2003-01-02 22:11:12.000000 Warnings: Warning 1292 Truncated incorrect datetime value: '10:20:10AM' drop table t1; select get_format(DATE, 'USA') as a; a %m.%d.%Y select get_format(TIME, 'internal') as a; a %H%i%s select get_format(DATETIME, 'eur') as a; a %Y-%m-%d %H.%i.%s select get_format(TIMESTAMP, 'eur') as a; a %Y-%m-%d %H.%i.%s select get_format(DATE, 'TEST') as a; a NULL select str_to_date('15-01-2001 12:59:59', GET_FORMAT(DATE,'USA')); str_to_date('15-01-2001 12:59:59', GET_FORMAT(DATE,'USA')) NULL Warnings: Warning 1411 Incorrect datetime value: '15-01-2001 12:59:59' for function str_to_date explain extended select makedate(1997,1), addtime("31.12.97 11.59.59.999999 PM", "1 1.1. id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: Note 1003 select makedate(1997,1) AS `makedate(1997,1)`,addtime('31.12.97 11.59.59.999 create table t1 (d date); insert into t1 values ('2004-07-14'),('2005-07-14'); select date_format(d,"%d") from t1 order by 1; date_format(d,"%d") 14 14 drop table t1; select str_to_date("2003-....01ABCD-02 10:11:12.0012", "%Y-%.%m%@-%d %H:%i:%S.%f") as a 2003-01-02 10:11:12.001200 create table t1 select str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f") a 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; describe t1; Field Type Null Key Default Extra f1 datetime(6) YES NULL f2 time(6) YES NULL f3 date YES NULL f4 date YES NULL f5 time YES NULL select * from t1; f1 f2 f3 f4 f5 2003-01-02 10:11:12.001200 10:11:12.001200 2003-01-02 0000-00-02 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; str_to_date(a,b) 0000-00-02 10:00:00.000000 create table t2 select str_to_date(a,b) from t1; describe t2; Field Type Null Key Default Extra str_to_date(a,b) datetime(6) YES NULL select str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f") as f1, str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S") as f2, str_to_date("2003-01-02", "%Y-%m-%d") as f3, str_to_date("02 10:11:12", "%d %H:%i:%S.%f") as f4, str_to_date("02 10:11:12", "%d %H:%i:%S") as f5, str_to_date("02 10", "%d %f") as f6; f1 f2 f3 f4 f5 f6 2003-01-02 10:11:12.001200 2003-01-02 10:11:12 2003-01-02 58:11:12.000000 58:11:12 48:0 Warnings: Warning 1292 Truncated incorrect datetime value: '2003-01-02 10:11:12.0012' drop table t1, t2; select str_to_date("2003-01-02 10:11:12.0012ABCD", "%Y-%m-%d %H:%i:%S.%f") as f1, addtime("-01:01:01.01 GGG", "-23:59:59.1") as f2, microsecond("1997-12-31 23:59:59.01XXXX") as f3; f1 f2 f3 2003-01-02 10:11:12.001200 -25:01:00.110000 10000 Warnings: Warning 1292 Truncated incorrect datetime value: '2003-01-02 10:11:12.0012ABCD' Warning 1292 Truncated incorrect time value: '-01:01:01.01 GGG' Warning 1292 Truncated incorrect datetime value: '1997-12-31 23:59:59.01XXXX' select str_to_date("2003-04-05 g", "%Y-%m-%d") as f1, str_to_date("2003-04-05 10:11:12.101010234567", "%Y-%m-%d %H:%i:%S.%f") as f2; f1 f2 2003-04-05 2003-04-05 10:11:12.101010 Warnings: Warning 1292 Truncated incorrect date value: '2003-04-05 g' Warning 1292 Truncated incorrect datetime value: '2003-04-05 10:11:12.101010234567' set names latin1; select date_format('2004-01-01','%W (%a), %e %M (%b) %Y'); date_format('2004-01-01','%W (%a), %e %M (%b) %Y') Thursday (Thu), 1 January (Jan) 2004 set lc_time_names=ru_RU; set names koi8r; select date_format('2004-01-01','%W (%a), %e %M (%b) %Y'); date_format('2004-01-01','%W (%a), %e %M (%b) %Y') ������� (��), 1 ������ (���.) 2004 set lc_time_names=de_DE; set names latin1; select date_format('2004-01-01','%W (%a), %e %M (%b) %Y'); date_format('2004-01-01','%W (%a), %e %M (%b) %Y') Donnerstag (Do), 1 Januar (Jan) 2004 set names latin1; set lc_time_names=en_US; create table t1 (f1 datetime); insert into t1 (f1) values ("2005-01-01"); insert into t1 (f1) values ("2005-02-01"); select date_format(f1, "%m") as d1, date_format(f1, "%M") as d2 from t1 order by date_format( d1 d2 02 February 01 January drop table t1; select str_to_date( 1, NULL ); str_to_date( 1, NULL ) NULL select str_to_date( NULL, 1 ); str_to_date( NULL, 1 ) NULL select str_to_date( 1, IF(1=1,NULL,NULL) ); str_to_date( 1, IF(1=1,NULL,NULL) ) NULL SELECT TIME_FORMAT("24:00:00", '%r'); TIME_FORMAT("24:00:00", '%r') 12:00:00 AM SELECT TIME_FORMAT("00:00:00", '%r'); TIME_FORMAT("00:00:00", '%r') 12:00:00 AM SELECT TIME_FORMAT("12:00:00", '%r'); TIME_FORMAT("12:00:00", '%r') 12:00:00 PM SELECT TIME_FORMAT("15:00:00", '%r'); TIME_FORMAT("15:00:00", '%r') 03:00:00 PM SELECT TIME_FORMAT("01:00:00", '%r'); TIME_FORMAT("01:00:00", '%r') 01:00:00 AM SELECT TIME_FORMAT("25:00:00", '%r'); TIME_FORMAT("25:00:00", '%r') 01:00:00 AM SELECT TIME_FORMAT("00:00:00", '%l %p'); TIME_FORMAT("00:00:00", '%l %p') 12 AM SELECT TIME_FORMAT("01:00:00", '%l %p'); TIME_FORMAT("01:00:00", '%l %p') 1 AM SELECT TIME_FORMAT("12:00:00", '%l %p'); TIME_FORMAT("12:00:00", '%l %p') 12 PM SELECT TIME_FORMAT("23:00:00", '%l %p'); TIME_FORMAT("23:00:00", '%l %p') 11 PM SELECT TIME_FORMAT("24:00:00", '%l %p'); TIME_FORMAT("24:00:00", '%l %p') 12 AM SELECT TIME_FORMAT("25:00:00", '%l %p'); TIME_FORMAT("25:00:00", '%l %p') 1 AM SELECT DATE_FORMAT('%Y-%m-%d %H:%i:%s', 1151414896); DATE_FORMAT('%Y-%m-%d %H:%i:%s', 1151414896) NULL Warnings: Warning 1292 Incorrect datetime value: '%Y-%m-%d %H:%i:%s' select str_to_date('04 /30/2004', '%m /%d/%Y'); str_to_date('04 /30/2004', '%m /%d/%Y') 2004-04-30 select str_to_date('04/30 /2004', '%m /%d /%Y'); str_to_date('04/30 /2004', '%m /%d /%Y') 2004-04-30 select str_to_date('04/30/2004 ', '%m/%d/%Y '); str_to_date('04/30/2004 ', '%m/%d/%Y ') 2004-04-30 "End of 4.1 tests" SELECT DATE_FORMAT("0000-01-01",'%W %d %M %Y') as valid_date; valid_date Sunday 01 January 0000 SELECT DATE_FORMAT("0000-02-28",'%W %d %M %Y') as valid_date; valid_date Tuesday 28 February 0000 SELECT DATE_FORMAT("2009-01-01",'%W %d %M %Y') as valid_date; valid_date Thursday 01 January 2009 "End of 5.0 tests" # Start of 5.1 tests # # Bug#58005 utf8 + get_format causes failed assertion: !str || str != Ptr' # SET NAMES utf8; SELECT LEAST('%', GET_FORMAT(datetime, 'eur'), CAST(GET_FORMAT(datetime, 'eur') AS CHAR exp % SET NAMES latin1; # End of 5.1 tests select time_format('2001-01-01 02:02:02', '%d.%m.%Y'); time_format('2001-01-01 02:02:02', '%d.%m.%Y') NULL select time_format('2001-01-01 02:02:02', '%d %T'); time_format('2001-01-01 02:02:02', '%d %T') NULL select time_format('01 02:02:02', '%d %T'); time_format('01 02:02:02', '%d %T') NULL select time_format('01 02:02:02', '%T'); time_format('01 02:02:02', '%T') 26:02:02 select time_format('2001-01-01 02:02:02', '%T'); time_format('2001-01-01 02:02:02', '%T') 02:02:02 # End of 10.2 test # # MDEV-31684 Add timezone information to DATE_FORMAT # SET @old_timezone= @@time_zone; # Using named timezones SET TIME_ZONE='Japan'; SELECT DATE_FORMAT('2009-10-04 22:23:00', '%z %Z') AS current_timezone; current_timezone +0900 JST SET @@time_zone='Europe/Moscow'; SELECT DATE_FORMAT('1965-02-17 22:23:00', '%z %Z') AS current_timezone; current_timezone +0300 MSK SELECT DATE_FORMAT('1965-12-31 22:23:00', '%z %Z') AS current_timezone; current_timezone +0300 MSK SELECT DATE_FORMAT('1985-06-01', '%z %Z'); DATE_FORMAT('1985-06-01', '%z %Z') +0400 MSD # Using positive and negative offset SET TIME_ZONE= '-05:30'; SELECT DATE_FORMAT('2009-10-04 22:23:00', '%z %Z') AS current_timezone; current_timezone -0530 -05:30 SET TIME_ZONE= '+04:30'; SELECT DATE_FORMAT('2009-10-04 22:23:00', '%z %Z') AS current_timezone; current_timezone +0430 +04:30 # Using UTC SET TIME_ZONE='UTC'; SELECT DATE_FORMAT('2009-10-04 22:23:00', '%z %Z') AS current_timezone; current_timezone +0000 UTC SET @@time_zone= @old_timezone; # More timezone test: # # Check for time zone with leap seconds # set time_zone='Europe/Moscow'; SELECT DATE_FORMAT('2023-03-01 01:30:00', '%z %Z'); DATE_FORMAT('2023-03-01 01:30:00', '%z %Z') +0300 MSK SELECT DATE_FORMAT('2023-04-01 01:30:00', '%z %Z'); DATE_FORMAT('2023-04-01 01:30:00', '%z %Z') +0400 MSD set time_zone='leap/Europe/Moscow'; SELECT DATE_FORMAT('2023-03-01 01:30:00', '%z %Z'); DATE_FORMAT('2023-03-01 01:30:00', '%z %Z') +0300 MSK SELECT DATE_FORMAT('2023-04-01 01:30:00', '%z %Z'); DATE_FORMAT('2023-04-01 01:30:00', '%z %Z') +0400 MSD # # Values around and in spring time-gap # set time_zone='MET'; # Normal value with DST SELECT DATE_FORMAT('2003-03-30 01:59:59', '%z %Z'); DATE_FORMAT('2003-03-30 01:59:59', '%z %Z') +0100 MET # Values around and in spring time-gap SELECT DATE_FORMAT('2023-03-26 01:59:59', '%z %Z'); DATE_FORMAT('2023-03-26 01:59:59', '%z %Z') +0100 MET SELECT DATE_FORMAT('2023-03-26 03:00:00', '%z %Z'); DATE_FORMAT('2023-03-26 03:00:00', '%z %Z') +0200 MEST # End of 11.3 test # MDEV-26112 STR_TO_DATE should work with lc_time_names # SET names utf8; set @@lc_time_names="uk_UA"; select str_to_date("1 березень 2010", "%e %M %Y"), str_to_date("1 березня 2010", "%e %M %Y"); str_to_date("1 березень 2010", "%e %M %Y") str_to_date("1 березня 2010", "%e %M %Y") 2010-03-01 2010-03-01 select str_to_date("Березень 15. 2010", "%M %d. %Y"); str_to_date("Березень 15. 2010", "%M %d. %Y") 2010-03-15 select str_to_date("пн 27 квітня 2026", "%a %e %M %Y"), str_to_date("неділя 28 грудня 2010", "%W %e %M %Y"); str_to_date("пн 27 квітня 2026", "%a %e %M %Y") str_to_date("неділя 28 грудня 2010", "%W %e %M %Y") 2026-04-27 2010-12-28 select str_to_date(date_format("2010-03-01","%e. %M %Y"), "%e. %M %Y"); str_to_date(date_format("2010-03-01","%e. %M %Y"), "%e. %M %Y") 2010-03-01 set @@lc_time_names="de_DE"; select str_to_date("1 März 2010", "%e %M %Y"), str_to_date("1 Juni 2010", "%e %M %Y"); str_to_date("1 März 2010", "%e %M %Y") str_to_date("1 Juni 2010", "%e %M %Y") 2010-03-01 2010-06-01 select str_to_date("1 Sep 2010", "%e %b %Y"), str_to_date("1 Mär 2010", "%e %b %Y"); str_to_date("1 Sep 2010", "%e %b %Y") str_to_date("1 Mär 2010", "%e %b %Y") 2010-09-01 2010-03-01 select str_to_date(date_format("2010-03-01","%e. %M %Y"), "%e. %M %Y"); str_to_date(date_format("2010-03-01","%e. %M %Y"), "%e. %M %Y") 2010-03-01 set @@lc_time_names="vi_VN"; select str_to_date("1 Tháng hai 2026", "%e %M %Y"), str_to_date("20 tháng 3 2010", "%e %M %Y"); str_to_date("1 Tháng hai 2026", "%e %M %Y") str_to_date("20 tháng 3 2010", "%e %M %Y") 2026-02-01 2010-03-20 select str_to_date("1 Tháng một 2026", "%e %M %Y"); str_to_date("1 Tháng một 2026", "%e %M %Y") 2026-01-01 # MDEV-38967 add to STR_TO_DATE() locale parameter (optional) # SELECT str_to_date('15 квітня 2026', '%d %M %Y', 'uk_UA'); str_to_date('15 квітня 2026', '%d %M %Y', 'uk_UA') 2026-04-15 SELECT str_to_date('20 févr. 2026', '%d %b %Y', 'fr_FR'); str_to_date('20 févr. 2026', '%d %b %Y', 'fr_FR') 2026-02-20 SELECT str_to_date('Понеділок 01 листопад 2026', '%W %d %M %Y', 'uk_UA') as a; a 2026-11-01 SELECT str_to_date('mar. 02 Mars 2026', '%a %d %M %Y', 'fr_FR'); str_to_date('mar. 02 Mars 2026', '%a %d %M %Y', 'fr_FR') 2026-03-02 select str_to_date("1 Tháng hai 2026", "%e %M %Y",'vi_VN'), str_to_date("20 tháng 3 2010", "%e str_to_date("1 Tháng hai 2026", "%e %M %Y",'vi_VN') str_to_date("20 tháng 3 2010", "%e %M %Y",' 2026-02-01 2010-03-20 select str_to_date("1 Tháng một 2026", "%e %M %Y",'vi_VN'); str_to_date("1 Tháng một 2026", "%e %M %Y",'vi_VN') 2026-01-01 SET lc_time_names = 'de_DE'; SELECT str_to_date('10 April 2026', '%d %M %Y','en_US'); str_to_date('10 April 2026', '%d %M %Y','en_US') 2026-04-10 SELECT str_to_date('10 травня 2026', '%d %M %Y', 'uk_UA'); str_to_date('10 травня 2026', '%d %M %Y', 'uk_UA') 2026-05-10 select str_to_date(date_format("2010-03-01","%e. %M %Y","uk_UA"), "%e. %M %Y","uk_UA") a 2010-03-01 select str_to_date(date_format("2010-03-01","%e. %M %Y","it_IT"), "%e. %M %Y","uk_UA") a NULL Warnings: Warning 1411 Incorrect datetime value: '1. marzo 2010' for function str_to_date select str_to_date(date_format("2010-03-01","%e. %M %Y","it_IT"), "%e. %M %Y","it_CH") a 2010-03-01 SELECT str_to_date('10 Dezember 2026', '%d %M %Y',NULL); str_to_date('10 Dezember 2026', '%d %M %Y',NULL) NULL SELECT str_to_date('10 Dezember 2026', '%d %M %Y',""); str_to_date('10 Dezember 2026', '%d %M %Y',"") NULL show warnings; Level Code Message Warning 1649 Unknown locale: '' Warning 1411 Incorrect datetime value: '10 Dezember 2026' for function str_to_date SELECT str_to_date('10 Dezember 2026', '%d %M %Y','aaaaa'); str_to_date('10 Dezember 2026', '%d %M %Y','aaaaa') NULL show warnings; Level Code Message Warning 1649 Unknown locale: 'aaaaa' Warning 1411 Incorrect datetime value: '10 Dezember 2026' for function str_to_date SELECT str_to_date('10 December 2026', '%d %M %Y','aaaaa'); str_to_date('10 December 2026', '%d %M %Y','aaaaa') 2026-12-10 show warnings; Level Code Message Warning 1649 Unknown locale: 'aaaaa' SELECT str_to_date('1 May 2026', '%d %M %Y','aaaaa'); str_to_date('1 May 2026', '%d %M %Y','aaaaa') 2026-05-01 show warnings; Level Code Message Warning 1649 Unknown locale: 'aaaaa' SELECT DATE_FORMAT('2010-03-01', '%d %M %Y','1'); DATE_FORMAT('2010-03-01', '%d %M %Y','1') 01 March 2010 show warnings; Level Code Message Warning 1649 Unknown locale: '1' SELECT DATE_FORMAT('2010-03-01', '%d %M %Y',POINT(1,1)); ERROR HY000: Illegal parameter data type point for operation 'date_format' SELECT DATE_FORMAT('2010-03-01', '%d %M %Y','de_DE'); DATE_FORMAT('2010-03-01', '%d %M %Y','de_DE') 01 März 2010 SELECT DATE_FORMAT('2010-03-01', '%d %M %Y',NULL); DATE_FORMAT('2010-03-01', '%d %M %Y',NULL) NULL SET @lc = 'de_DE'; SELECT str_to_date('18 Oktober 2022', '%d %M %Y', @lc); str_to_date('18 Oktober 2022', '%d %M %Y', @lc) 2022-10-18 prepare stmt from "SELECT str_to_date(?, '%d %M %Y', ?);"; execute stmt using '20 september 2026','da_DK'; str_to_date(?, '%d %M %Y', ?) 2026-09-20 execute stmt using '20 вересня 2026','uk_UA'; str_to_date(?, '%d %M %Y', ?) 2026-09-20 SELECT str_to_date('20.févr..2026', '%d.%b.%Y', 'fr_FR'); str_to_date('20.févr..2026', '%d.%b.%Y', 'fr_FR') 2026-02-20 SELECT str_to_date('10.March.2026', '%d.%M.%Y', 'en_US'); str_to_date('10.March.2026', '%d.%M.%Y', 'en_US') 2026-03-10 SELECT str_to_date('12. Mär 2026', '%d.%M %Y', 'de_DE'); str_to_date('12. Mär 2026', '%d.%M %Y', 'de_DE') 2026-03-12 SELECT str_to_date('1 Tháng một 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng hai 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng ba 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng tư 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng năm 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng sáu 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng bảy 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng tám 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng chín 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng mười 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng mười một 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng mười hai 2026', '%d %M %Y','vi_VN'); str_to_date('1 Tháng một 2026', '%d %M %Y','vi_VN') 2026-01-01 str_to_date('1 Tháng hai 2026', '%d %M %Y','vi_VN') 2026-02-01 str_to_date('1 Tháng ba 2026', '%d %M %Y','vi_VN') 2026-03-01 str_to_date('1 Tháng tư 2026', '%d %M %Y','vi_VN') 2026-04-01 str_to_date('1 Tháng năm 2026', '%d %M %Y','vi_VN') 2026-05-01 str_to_date('1 Tháng sáu 2026', '%d %M %Y','vi_VN') 2026-06-01 str_to_date('1 Tháng bảy 2026', '%d %M %Y','vi_VN') 2026-07-01 str_to_date('1 Tháng tám 2026', '%d %M %Y','vi_VN') 2026-08-01 str_to_date('1 Tháng chín 2026', '%d %M %Y','vi_VN') 2026-09-01 str_to_date('1 Tháng mười 2026', '%d %M %Y','vi_VN') 2026-10-01 str_to_date('1 Tháng mười một 2026', '%d %M %Y','vi_VN') 2026-11-01 str_to_date('1 Tháng mười hai 2026', '%d %M %Y','vi_VN') 2026-12-01 SELECT str_to_date('1 Tháng 1 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 2 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 3 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 4 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 5 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 6 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 7 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 8 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 9 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 10 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 11 2026', '%d %M %Y','vi_VN'), str_to_date('1 Tháng 12 2026', '%d %M %Y','vi_VN'); str_to_date('1 Tháng 1 2026', '%d %M %Y','vi_VN') 2026-01-01 str_to_date('1 Tháng 2 2026', '%d %M %Y','vi_VN') 2026-02-01 str_to_date('1 Tháng 3 2026', '%d %M %Y','vi_VN') 2026-03-01 str_to_date('1 Tháng 4 2026', '%d %M %Y','vi_VN') 2026-04-01 str_to_date('1 Tháng 5 2026', '%d %M %Y','vi_VN') 2026-05-01 str_to_date('1 Tháng 6 2026', '%d %M %Y','vi_VN') 2026-06-01 str_to_date('1 Tháng 7 2026', '%d %M %Y','vi_VN') 2026-07-01 str_to_date('1 Tháng 8 2026', '%d %M %Y','vi_VN') 2026-08-01 str_to_date('1 Tháng 9 2026', '%d %M %Y','vi_VN') 2026-09-01 str_to_date('1 Tháng 10 2026', '%d %M %Y','vi_VN') 2026-10-01 str_to_date('1 Tháng 11 2026', '%d %M %Y','vi_VN') 2026-11-01 str_to_date('1 Tháng 12 2026', '%d %M %Y','vi_VN') 2026-12-01 # # MDEV-39721: SIGSEGV in check_word|(extract_date_time|extract_oracle_date_time) # # locale as a session var SET SESSION lc_time_names='ar_DZ'; SELECT STR_TO_DATE('Wednesday, June 2, 2014', '%W, %M %e, %Y'); STR_TO_DATE('Wednesday, June 2, 2014', '%W, %M %e, %Y') NULL Warnings: Level Warning Code 1411 Message Incorrect datetime value: 'Wednesday, June 2, 2014' for function str_to_date # locale as third param to STR_TO_DATE SELECT STR_TO_DATE('Wednesday, June 2, 2014', '%W, %M %e, %Y', 'ar_DZ'); STR_TO_DATE('Wednesday, June 2, 2014', '%W, %M %e, %Y', 'ar_DZ') NULL Warnings: Level Warning Code 1411 Message Incorrect datetime value: 'Wednesday, June 2, 2014' for function str_to_date # End of 12.3 test SET @@lc_time_names=DEFAULT; SET NAMES latin1;
¤ Dauer der Verarbeitung: 0.17 Sekunden (vorverarbeitet am 2026-10-08) ¤*© Formatika GbR, Deutschland |
|
||||||||||||||
2026-10-10