xref: /PHP-8.0/ext/pdo_dblib/tests/datetime2.phpt (revision a0ed09f9)
1--TEST--
2PDO_DBLIB: DATETIME2 column data
3--SKIPIF--
4<?php
5if (!extension_loaded('pdo_dblib')) die('skip not loaded');
6require __DIR__ . '/config.inc';
7if (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');
8?>
9--FILE--
10<?php
11require __DIR__ . '/config.inc';
12
13$sql = "SELECT convert(datetime2, '10231017 10:22:44.1355318') AS [d]";
14
15var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT));
16
17$stmt = $db->query($sql);
18var_dump($stmt->fetch(PDO::FETCH_ASSOC));
19
20$db->setAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT, 1);
21var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT));
22$stmt = $db->query($sql);
23var_dump($stmt->fetch(PDO::FETCH_ASSOC));
24
25?>
26--EXPECT--
27bool(false)
28array(1) {
29  ["d"]=>
30  string(19) "1023-10-17 10:22:44"
31}
32bool(true)
33array(1) {
34  ["d"]=>
35  string(30) "Oct 17 1023 10:22:44:1355318AM"
36}
37