After porting the application to a new server with updated software (ported from php 5.2.17 → 5.3.15, FreeTDS 0.64 → 0.82)
SELECT GETDATE()
and any other datetime function / column creates something similar to:
2012-06-219 51:527:
I know what I can use convertin select, but there are many stored procedures in DB that I cannot change.
I tried changing /etc/locales.confand installing date format = %Y-%m-%d %H:%M:%Sand using ini_set('mssql.datetimeconvert',1);, but freetds seems to ignore it and returnsAug 06 2012 09:33AM
Is there a way to get datetime columns in standard format without changing every query?
source
share