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