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

Both sides previous revision Previous revision
Next revision
Previous revision
v5:reference:connection:unixtimestamp [2016/01/17 01:44]
mnewnham ↷ Page moved from v5:reference:unixtimestamp to v5:reference:connection:unixtimestamp
v5: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.1452991494.txt.gz · Last modified: 2017/04/21 11:32 (external edit)