View Issue Details

IDProjectCategoryView StatusLast Update
0005784OXID eShop (all versions)4.01. Database handlingpublic2014-06-10 15:01
Reporterdreibein Assigned To 
Status resolvedResolutionfixed 
PlatformLinuxOSTurboleo OS Version3.2.0-63-generic
Product Version4.8.1 / 5.1.1 
Target Version4.9.0_5.2.0_beta1Fixed in Version4.8.7 / 5.1.7 
Summary0005784: Wrong Data Format for SQL Update of Date field
Descriptione.g. in the myorder.php the value of the oxbilldate is set as d.m.Y, the SQL defintion of it is Y-m-d. If the SQL Server doesn't correct it, it leads to wrong values of all dates stored in the Database.
TagsNo tags attached.
PHP Versionany
Database Versionany



2014-06-03 16:41

reporter   ~0009934

Why would you set "d.m.Y", if its not the right date-format?

from the setup/sql/database.sql-file:

CREATE TABLE `oxorder` (
-- ...
`OXBILLDATE` date NOT NULL default '0000-00-00' COMMENT 'Invoice sent date',
-- ...
`OXSENDDATE` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Order shipping date',
-- ...

regarding the documentation the sql-setup is correct

"The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in 'YYYY-MM-DD' format."

Even oxutilsdate::formatDBDate is using "Y-m-d"

Linas Kukulskis

2014-06-10 15:01

reporter   ~0009950

changed format