|  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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: andremoniz at gmail dot com
New email:
PHP Version: OS:


 [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-2023 The PHP Group
All rights reserved.
Last updated: Thu Sep 28 09:01:24 2023 UTC