1--TEST-- 2PDO_DBLIB: DATETIME2 column data 3--EXTENSIONS-- 4pdo_dblib 5--SKIPIF-- 6<?php 7require __DIR__ . '/config.inc'; 8$db = getDbConnection(); 9if (in_array($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION), ['4.2', '4.6', '5.0', '6.0', '7.0', '7.1', '7.2'])) die('skip feature unsupported by this TDS version'); 10?> 11--FILE-- 12<?php 13require __DIR__ . '/config.inc'; 14 15$db = getDbConnection(); 16 17$sql = "SELECT convert(datetime2, '10231017 10:22:44.1355318') AS [d]"; 18 19var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); 20 21$stmt = $db->query($sql); 22var_dump($stmt->fetch(PDO::FETCH_ASSOC)); 23 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) "1023-10-17 10:22:44" 35} 36bool(true) 37array(1) { 38 ["d"]=> 39 string(30) "Oct 17 1023 10:22:44:1355318AM" 40} 41