php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #72141 Sybase not loading date format from Freetds
Submitted: 2016-05-03 09:38 UTC Modified: 2017-10-31 21:58 UTC
Votes:5
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 Developer Edit
 [2016-05-03 09:38 UTC] andremoniz at gmail dot com 
Description:
------------
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 
[default]
        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 7.0.6-1+donate.sury.org~trusty+1 (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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2016-05-03 13:38 UTC] andremoniz at gmail dot com 
I am thinking this is related to 
https://github.com/php/php-src/blob/PHP-7.0.6/ext/pdo_dblib/dblib_stmt.c#L322
 [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] adambaratz@php.net
-Status: Open +Status: Duplicate
 [2017-10-31 21:58 UTC] adambaratz@php.net 
See #74243.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sun Oct 26 21:00:01 2025 UTC