Esempi in PHP per DBSQLite::hourStart

Esempio n. 1

File: DBSQLiteTest.php Progetto: abcarroll/DABL

 function testHourStart()
 {
     $sql = 'SELECT ' . $this->pdoSQLite->hourStart("'2014-05-05 10:05:15'");
     $expected = '2014-05-05 10:00:00';
     $actual = $this->pdoSQLite->query($sql)->fetchColumn();
     $this->assertEquals($expected, $actual, $sql . ' should have returned ' . $expected);
     $sql = 'SELECT ' . $this->pdoSQLite->hourStart("'bad date'");
     $actual = $this->pdoSQLite->query($sql)->fetchColumn();
     $this->assertNull($actual, $sql . ' should have returned null');
 }