bug_54648.phpt 615 B

1234567891011121314151617181920212223242526
  1. --TEST--
  2. PDO_DBLIB: Does not force correct dateformat
  3. --SKIPIF--
  4. <?php
  5. if (!extension_loaded('pdo_dblib')) die('skip not loaded');
  6. require dirname(__FILE__) . '/config.inc';
  7. ?>
  8. --FILE--
  9. <?php
  10. require dirname(__FILE__) . '/config.inc';
  11. $db->query('set dateformat ymd');
  12. $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");
  13. var_dump($rs->fetchAll(PDO::FETCH_ASSOC));
  14. echo "Done.\n";
  15. ?>
  16. --EXPECT--
  17. array(1) {
  18. [0]=>
  19. array(2) {
  20. ["sdt"]=>
  21. string(19) "1950-01-18 23:00:00"
  22. ["dt"]=>
  23. string(19) "2030-01-01 23:59:59"
  24. }
  25. }
  26. Done.