DATE: Getting Literal Data Type
/**
* Returns the SQL keyword indicating the literal following it is a date
*
* @return string the query fragment your DBMS needs
*/
function getDateLiteralType() {
return $this->DateLiteralType;
}
require 'connect.inc';
$query = 'INSERT INTO t (daf) VALUES (' .
$p->getDateLiteralType() . " '2004-11-10')";
echo $query;
$db->query($query);
$db->query("DELETE FROM t WHERE cf = 'n/a'");
fbsql
INSERT INTO t (daf) VALUES ( DATE '2004-11-10') |
mysql
INSERT INTO t (daf) VALUES ( '2004-11-10') |