InfiniDB Community

date_format(a_time,'%x%v') result is inconsistent

Bug #1165971 reported by afareg
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
InfiniDB Community
New
Undecided
Unassigned

Bug Description

mysql> select o.pay_time ,date_format(o.pay_time,'%x%v') ,date_format('2012-12-31 17:18:41','%x%v') from i_order o where o.id=67148595 ;
+---------------------+--------------------------------+-------------------------------------------+
| pay_time | date_format(o.pay_time,'%x%v') | date_format('2012-12-31 17:18:41','%x%v') |
+---------------------+--------------------------------+-------------------------------------------+
| 2012-12-31 17:18:41 | 201201 | 201301 |
+---------------------+--------------------------------+-------------------------------------------+
1 row in set (0.11 sec)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.