Wrong datetime - PHP+ SQL Server

Question

echo date('d/m/Y H:i:s'); 
//output: 13/12/2012 11:10:57

print_r(getDataArray($dblink, 'select current_timestamp')); 
//output: Array ( [0] => Array ( [computed] => **2012-04-12 11110:05** ) )

When I try to get a "current_timestamp" + php + sql server, I get an error, an incorrect date. Can anyone help me?

date convert in mssql config (php.ini) is "off"

that's a problem in locale.conf ? /etc/locale.conf ....

thanks

Is mssql installed on same server where PHP is running? (How did you install Microsoft SQL server on CentOS?) — Bogdan Burym, Dec 13 '12 at 13:24
@BogdanBurim no.. another server. (i use mssql - php 5.2.10) — Eduardo Stuart, Dec 13 '12 at 13:28
You need to check those server settings (locale, date and time) — Bogdan Burym, Dec 13 '12 at 13:29
The SQL Server is configured correctly. The problem only happens when I use php + mssql. When I run a query ... — Eduardo Stuart, Dec 13 '12 at 13:31

score 0 · Accepted Answer · answered Dec 13 '12 at 14:15

0

The problem can be with the format that datetime columns are returned in.

Try this in your php.ini :

After this line:

;mssql.datetimeconvert = On

Add this line:

mssql.datetimeconvert = Off

answered Dec 13 '12 at 14:15

Bogdan Burym

5,482
2
27
46

I've changed this parameter to "off" .. didn't work anyway. very strange :/ – Eduardo Stuart Dec 13 '12 at 14:30
2

This sounds similar to your problem.. http://blog.kotowicz.net/2009/09/weird-date-format-from-freetds-with.html – Bogdan Burym Dec 13 '12 at 14:36

score -1 · Answer 2 · answered Mar 07 '13 at 03:05

-1

Try:

After connection execute query:

SET DATEFORMAT ymd;

PHP:

odbc_exec($conn, "SET DATEFORMAT ymd");

answered Mar 07 '13 at 03:05

Bialy7

87
4

Wrong datetime - PHP+ SQL Server

2 Answers2