diff options
Diffstat (limited to 'ext/pdo_dblib/tests/datetime2.phpt')
-rw-r--r-- | ext/pdo_dblib/tests/datetime2.phpt | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/ext/pdo_dblib/tests/datetime2.phpt b/ext/pdo_dblib/tests/datetime2.phpt new file mode 100644 index 0000000000..becf1b0a8f --- /dev/null +++ b/ext/pdo_dblib/tests/datetime2.phpt @@ -0,0 +1,36 @@ +--TEST-- +PDO_DBLIB: DATETIME2 column data +--SKIPIF-- +<?php +if (!extension_loaded('pdo_dblib')) die('skip not loaded'); +require __DIR__ . '/config.inc'; +if (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'); +?> +--FILE-- +<?php +require __DIR__ . '/config.inc'; + +$sql = "SELECT convert(datetime2, '10231017 10:22:44.1355318') AS [d]"; + +var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); + +$stmt = $db->query($sql); +var_dump($stmt->fetch(PDO::FETCH_ASSOC)); + +$db->setAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT, 1); +var_dump($db->getAttribute(PDO::DBLIB_ATTR_DATETIME_CONVERT)); +$stmt = $db->query($sql); +var_dump($stmt->fetch(PDO::FETCH_ASSOC)); + +?> +--EXPECT-- +bool(false) +array(1) { + ["d"]=> + string(19) "1023-10-17 10:22:44" +} +bool(true) +array(1) { + ["d"]=> + string(30) "Oct 17 1023 10:22:44:1355318AM" +} |