ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== dbTimeStamp ======
~~NOTOC~~
<WRAP right box>
== syntax ==
  string dbTimeStamp(){
         mixed $timestamp
         }
         
</WRAP>
===== Description =====
The function ''dbTimeStamp()'' accepts a number of different types of parameters, and returns a database-specific dateTime string. This can then be used in SQL statements. The returned value differs from one database to another.

Note that the returned value already includes any required quoting
==== Parameters ====
=== PHP DateTime Option ===
<code php>
/*
 * Connection to Oracle database assumed
 */

$dateTime=new DateTime("2012-07-08 11:14:15.638276");

$d = $db->dbTimeStamp($dateTime);
/*
 * Returns the following string: TO_DATE('2012-07-08 11:14:15','RRRR-MM-DD, HH24:MI:SS')
 */
$SQL = "SELECT * FROM record WHERE date_time_field=$d";
</code>

=== Unix Timestamp Option ===
<code php>
/*
 * Connection to Oracle database assumed
 */

$timestamp = date('Y-m-d');

$d = $db->dbTimeStamp($timestamp);
/*
 * Returns the following string: TO_DATE('2015-07-19 00:00:00','RRRR-MM-DD, HH24:MI:SS')
 */
$SQL = "SELECT * FROM record WHERE date_time_field=$d";
</code>
=== ISO Date String Option ===
<code php>
/*
 * Connection to IBM DB2 database assumed
 */

$timestampString = '2015-01-01 19:30:15';

$d = $db->dbTimeStamp($timestampString);
/*
 * Returns the following string: TO_DATE('2015-01-01 19:30:15','YYYY-MM-DD HH24:MI:SS')
 */
$SQL = "SELECT * FROM record WHERE date_time_field=$d";
</code>