1--TEST-- 2PDO_DBLIB: PDO::DBLIB_ATTR_DATETIME_CONVERT 3--EXTENSIONS-- 4pdo_dblib 5--SKIPIF-- 6<?php 7require __DIR__ . '/config.inc'; 8getDbConnection(); 9?> 10--FILE-- 11<?php 12require __DIR__ . '/config.inc'; 13 14$db = getDbConnection(); 15 16$sql = "SELECT convert(datetime, '20171027 10:22:44.135') AS [d]"; 17 18var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 19 20$stmt = $db->query($sql); 21var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 22 23// assume default date format: %b %e %Y %I:%M:%S:%z%p 24$db->setAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT, 1); 25var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 26$stmt = $db->query($sql); 27var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 28 29?> 30--EXPECT-- 31bool(false) 32array(1) { 33 ["d"]=> 34 string(19) "2017-10-27 10:22:44" 35} 36bool(true) 37array(1) { 38 ["d"]=> 39 string(26) "Oct 27 2017 10:22:44:137AM" 40} 41