ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:unixtimestamp

unixTimeStamp

Use of 64 bit processors and later versions of PHP have effectively made this function obsolete. It may be removed in later releases of ADOdb

syntax
float dbObject::unixDate(){
       string $timestamp
}
       

Description

The static function unixTimeStamp() Parses the timestamp string $str and returns it in UNIX mktime format (.g. a number indicating the seconds after January 1st, 1970.

It expects the date passed to be in one of the following formats:

  • “Y-m-d, H:i:s” (1970-12-24, 00:00:00)
  • “Y-m-d H:i:s” (1970-12-24 00:00:00)
  • “YmdHis” (19701225000000)
  • “M d Y h:i:s” (Dec 25 1970 00:00:00AM) (SQL Server and Sybase only) (the 3 letter month strings are controlled by a global array, which might need localisation).

For databases that do not support the functionality, the function makes use of ADOdb time handling library.

Usage

SQL Server example

/*
 * Connection to SQL Server database assumed
 */
$d = $db::unixDate(strtotime('1920-10-10 00:00:00'));
print $d;
/*
 * returns -1553450400
 */
print date('Y-m-d',$d);
/*
 * Returns the following string: '1920-10-10'
 */
v5/reference/connection/unixtimestamp.txt · Last modified: 2020/01/05 19:21 by mnewnham