|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #72141 Sybase not loading date format from Freetds
Submitted: 2016-05-03 09:38 UTC Modified: 2017-10-31 21:58 UTC
Avg. Score:4.8 ± 0.4
Reproduced:5 of 5 (100.0%)
Same Version:2 (40.0%)
Same OS:1 (20.0%)
From: andremoniz at gmail dot com Assigned:
Status: Duplicate Package: PDO DBlib
PHP Version: 7.0.6 OS: Ubuntu 14.04.4 LTS
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
Solve the problem:
11 + 47 = ?
Subscribe to this entry?

 [2016-05-03 09:38 UTC] andremoniz at gmail dot com
The bug is that php7.0-sybase is not loading locales.conf date format from freetds.

If I go back to php5 it works.
The locales.conf has 
        date format = %Y-%m-%d %H:%M:%S.%z

But when results come from database it returns in this format:
%Y-%m-%d %H:%M:%S

freetds version 8.0.

PHP (cli) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
    with Xdebug v2.4.0, Copyright (c) 2002-2016, by Derick Rethans 


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2016-05-03 13:38 UTC] andremoniz at gmail dot com
I am thinking this is related to
 [2017-08-09 20:02 UTC] maxiwheat at gmail dot com
Would be great if the format would at least be customizable in php.ini or just go back to use the format friom freetds' locales.conf. We are now stuck with a fixed format that us missing some info and it's bad.
 [2017-10-31 21:58 UTC]
-Status: Open +Status: Duplicate
 [2017-10-31 21:58 UTC]
See #74243.
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Mon Jan 17 23:03:42 2022 UTC