< DATE: Setting Literal Data Type   (Previous) Table of Contents (Next)   DATE: Supported Ranges >

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')