xref: /php-src/ext/pdo_dblib/tests/datetime2.phpt (revision d6a0b3af) 
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