ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:dbtimestamp

dbTimeStamp

syntax
string dbTimeStamp(){
       mixed $timestamp
       }
       

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

/*
 * 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";

Unix Timestamp Option

/*
 * 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";

ISO Date String Option

/*
 * 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";
v5/reference/connection/dbtimestamp.txt · Last modified: 2016/01/17 00:31 by mnewnham