ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:unixtimestamp

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
reference:unixtimestamp [2015/07/27 01:27] – created mnewnhamv5:reference:connection:unixtimestamp [2020/01/05 19:21] (current) mnewnham
Line 6: Line 6:
 <WRAP right box> <WRAP right box>
 == syntax == == syntax ==
-  int dbObject::unixDate(){ +  float dbObject::unixDate(){ 
-         float $timestamp, +         string $timestamp 
-          +  }
-         }+
                    
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
-The **static** function ''unixTimeStamp()'' Parses the timestamp string $<b>str</b> and returns it in unix mktime format(g. a number indicating the seconds after January 1st, 1970). It expects the date to be in "Y-m-d, H:i:s" (1970-12-24, 00:00:00) or "Y-m-d H:i:s" (1970-12-24 00:00:00) or "YmdHis" (19701225000000) format, except for Sybase and Microsoft SQL Server, where "M d Y h:i:s" (Dec 25 1970 00:00:00AM) is also accepted (the 3 letter month +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.  
-strings are controlled by a global array, which might need localisation). For versions of PHP earlier than 5, this function could be used to bypass limitations of dates before 1<sup>st</sup> January 1970. For databases that do not support the functionality, the function makes use of ADOdb time handling library.+ 
 +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 ===== ===== Usage =====
Line 22: Line 28:
  * Connection to SQL Server database assumed  * Connection to SQL Server database assumed
  */  */
-$d = $db::unixDate(strtotime('1920-10-10'));+$d = $db::unixDate(strtotime('1920-10-10 00:00:00'));
 print $d; print $d;
 /* /*
v5/reference/connection/unixtimestamp.1437953254.txt.gz · Last modified: 2017/04/21 11:32 (external edit)