Differences

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

--- v5:reference:connection:unixtimestamp [2016/01/17 01:44] – ↷ Page moved from v5:reference:unixtimestamp to v5:reference:connection:unixtimestamp mnewnham
+++ v5:reference:connection:unixtimestamp [2020/01/05 19:19] – [SQL Server example] mnewnham
@@ Line 13: / Line 13: @@
 </WRAP>
 ===== Description =====
-The **static** function ''unixTimeStamp()'' Parses the timestamp string $<b>str</b> and returns it in unix mktime format(e 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 =====
@@ Line 22: / Line 29: @@
  * 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;
 /*