PHP: return pdo_sqlsrv datetime column as object (Linux MSSQL driver)

Question

The pdo_sqlsrv PHP driver always returns a datetime column from MS SQL as a String. I want it to be an object (just like w/ the official Windows MSSQL driver for PHP)

I explicitly set ReturnDatesAsStrings to false in the connect parameters for the DB connection, and tried setting the mssql.datetimeconvert to both On and Off in my php.ini, but none of that yields a datetime object in PHP as a result. Only Strings: Feb 17 2016 09:48:56:213AM

I retrieve the data via sqlsrv_fetch_object(sqlsrv_query($connection, $querystr))

Through Google, I can only find people having the opposite problem (wanting to return dates as strings, not objects)... But I want the Linux version to be compatible to the Windows version in that regard.

Todd · Accepted Answer · 2016-03-28 01:50:17Z

1

I've found no low-level solution, other than creating a function to ensure the date is converted to an object:

Function cdate($dat) {
    return (gettype($dat)=="string" ? new DateTime($dat) : $dat);
}

answered Mar 28, 2016 at 1:50

Todd

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

NoMad Over a year ago

I gave up on finding functions or parameters to force the PHP Sql Driver to return DateTime objects, so I wrote this helper function: if(gettype($this->timestamp) == 'string') return DateTime::createFromFormat('M j Y h:i:s:uA', $this->timestamp);

Collectives™ on Stack Overflow

PHP: return pdo_sqlsrv datetime column as object (Linux MSSQL driver)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related