/** * Test for seconds extraction from date. * * @return void * * @since 12.1 */ public function test__toStringSecond() { $q = new JDatabaseQueryPostgresql($this->dbo); $q->select($q->second($q->quoteName('col')))->from('table'); $this->assertEquals(PHP_EOL . "SELECT EXTRACT (SECOND FROM \"col\")" . PHP_EOL . "FROM table", (string) $q); }
/** * Test for seconds extraction from date. * * @return void * * @since 12.1 */ public function test__toStringSecond() { $q = new JDatabaseQueryPostgresql($this->dbo); $q->select($q->second($q->quoteName('col')))->from('table'); $this->assertThat((string) $q, $this->equalTo("\nSELECT EXTRACT (SECOND FROM \"col\")\nFROM table")); }