Google
  Web www.spinics.net

mssql datetime weirdness

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Hi,

I am facing some weird results when querying a MSSQL 2008 server, giving
me just plain wrong results like "2012-01-01 32747:02" (usage of
"mssql_fetch_assoc" originates from the original code fragment):

Here's what I do:

--------CUT---------
<?php
ini_set( 'mssql.datetimeconvert', false );
$dbh = mssql_pconnect( "mssql.example.com", "foor", "bar" );
mssql_select_db( "foobar", $dbh );
$query = "SELECT GETDATE() AS broken";
$sth = mssql_query( $query, $dbh );
$resultArray = array();
while ( $row = mssql_fetch_assoc( $sth ) ) {
  print "datetimeconvert false - broken date: ".$row['broken']."<br>\n";
}

ini_set( 'mssql.datetimeconvert', true );
$query = "SELECT GETDATE() AS good";
$sth = mssql_query( $query, $dbh );
$resultArray = array();
while ( $row = mssql_fetch_assoc( $sth ) ) {
  print "datetimeconvert true - date ok: ".$row['good']."<br>\n";
}
--------CUT---------

When run in a browser, I get this:

--------CUT---------
mssql.datetimeconvert false - broken date: 2012-01-01 32659:02
mssql.datetimeconvert true - date ok: Jan 30 2012 04:01:35:903PM
--------CUT---------

On the other hand, when I run the script via CLI, I get this

--------CUT---------
mssql.datetimeconvert false - broken date: 2012-01-01 00:02:16<br>
mssql.datetimeconvert true - date ok: Jan 30 2012 04:01:35:903PM<br>
--------CUT---------

When mssql.datetimeconvert is false, the date is just completely wrong
... any ideas?

Some stats:

"vanilla" and up2date fedora core 16
apache 2.2.21
php-5.3.8-3.fc16.x86_64 with
php-mssql-5.3.8-3.fc16.x86_64
freetds-0.91-1.fc16.x86_64

With regrads to freetds, I am not having any troubles retrieving
datetime information using the JTDS JDBC driver.

Udo

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Plagiarism Notes]     [Postgresql]     [Yosemite News]

Powered by Linux