====== 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 ~~NOTOC~~ == 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' */