====== bindDate ====== ~~NOTOC~~ == syntax == string bindDate(){ float $timestamp } ===== Description ===== The function ''bindDate()'' accepts a Unix Timestamp value, and returns a database-specific date string suitable for embedding into bind statements. The returned value differs from one database to another. ===== Usage ===== ==== MySQL example ==== /* * Connection to MySQL database assumed */ $date = date('Y-m-d'); $d = $db->bindDate($date); /* * Returns the following string: 2015-07-19 */ ==== Oracle Example ==== /* * Connection to Oracle database assumed */ $date = date('Y-m-d'); $d = $db->dbDate($date); /* * Returns the following string: TO_DATE('2015-07-19','YYYY-MM-DD') */ $SQL = "SELECT * FROM record WHERE date_field=$d";