xref: /php-src/ext/pdo_dblib/tests/bug_54648.phpt (revision d6a0b3af)
1--TEST--
2PDO_DBLIB: Does not force correct dateformat
3--EXTENSIONS--
4pdo_dblib
5--SKIPIF--
6<?php
7require __DIR__ . '/config.inc';
8getDbConnection();
9?>
10--FILE--
11<?php
12require __DIR__ . '/config.inc';
13$db = getDbConnection();
14$db->query('set dateformat ymd');
15$rs = $db->query("select cast('1950-01-18 23:00:00' as smalldatetime) as sdt, cast('2030-01-01 23:59:59' as datetime) as dt");
16var_dump($rs->fetchAll(PDO::FETCH_ASSOC));
17echo "Done.\n";
18?>
19--EXPECT--
20array(1) {
21  [0]=>
22  array(2) {
23    ["sdt"]=>
24    string(19) "1950-01-18 23:00:00"
25    ["dt"]=>
26    string(19) "2030-01-01 23:59:59"
27  }
28}
29Done.
30