Date.php 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184
  1. <?php
  2. // +----------------------------------------------------------------------+
  3. // | PHP versions 4 and 5 |
  4. // +----------------------------------------------------------------------+
  5. // | Copyright (c) 1998-2006 Manuel Lemos, Tomas V.V.Cox, |
  6. // | Stig. S. Bakken, Lukas Smith |
  7. // | All rights reserved. |
  8. // +----------------------------------------------------------------------+
  9. // | MDB2 is a merge of PEAR DB and Metabases that provides a unified DB |
  10. // | API as well as database abstraction for PHP applications. |
  11. // | This LICENSE is in the BSD license style. |
  12. // | |
  13. // | Redistribution and use in source and binary forms, with or without |
  14. // | modification, are permitted provided that the following conditions |
  15. // | are met: |
  16. // | |
  17. // | Redistributions of source code must retain the above copyright |
  18. // | notice, this list of conditions and the following disclaimer. |
  19. // | |
  20. // | Redistributions in binary form must reproduce the above copyright |
  21. // | notice, this list of conditions and the following disclaimer in the |
  22. // | documentation and/or other materials provided with the distribution. |
  23. // | |
  24. // | Neither the name of Manuel Lemos, Tomas V.V.Cox, Stig. S. Bakken, |
  25. // | Lukas Smith nor the names of his contributors may be used to endorse |
  26. // | or promote products derived from this software without specific prior|
  27. // | written permission. |
  28. // | |
  29. // | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
  30. // | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
  31. // | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |
  32. // | FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE |
  33. // | REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, |
  34. // | INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
  35. // | BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS|
  36. // | OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED |
  37. // | AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT |
  38. // | LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY|
  39. // | WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
  40. // | POSSIBILITY OF SUCH DAMAGE. |
  41. // +----------------------------------------------------------------------+
  42. // | Author: Lukas Smith <smith@pooteeweet.org> |
  43. // +----------------------------------------------------------------------+
  44. //
  45. // $Id$
  46. //
  47. /**
  48. * @package MDB2
  49. * @category Database
  50. * @author Lukas Smith <smith@pooteeweet.org>
  51. */
  52. /**
  53. * Several methods to convert the MDB2 native timestamp format (ISO based)
  54. * to and from data structures that are convenient to worth with in side of php.
  55. * For more complex date arithmetic please take a look at the Date package in PEAR
  56. *
  57. * @package MDB2
  58. * @category Database
  59. * @author Lukas Smith <smith@pooteeweet.org>
  60. */
  61. class MDB2_Date
  62. {
  63. // {{{ mdbNow()
  64. /**
  65. * return the current datetime
  66. *
  67. * @return string current datetime in the MDB2 format
  68. * @access public
  69. */
  70. public static function mdbNow()
  71. {
  72. return date('Y-m-d H:i:s');
  73. }
  74. // }}}
  75. // {{{ mdbToday()
  76. /**
  77. * return the current date
  78. *
  79. * @return string current date in the MDB2 format
  80. * @access public
  81. */
  82. public static function mdbToday()
  83. {
  84. return date('Y-m-d');
  85. }
  86. // }}}
  87. // {{{ mdbTime()
  88. /**
  89. * return the current time
  90. *
  91. * @return string current time in the MDB2 format
  92. * @access public
  93. */
  94. public static function mdbTime()
  95. {
  96. return date('H:i:s');
  97. }
  98. // }}}
  99. // {{{ date2Mdbstamp()
  100. /**
  101. * convert a date into a MDB2 timestamp
  102. *
  103. * @param int hour of the date
  104. * @param int minute of the date
  105. * @param int second of the date
  106. * @param int month of the date
  107. * @param int day of the date
  108. * @param int year of the date
  109. *
  110. * @return string a valid MDB2 timestamp
  111. * @access public
  112. */
  113. public static function date2Mdbstamp($hour = null, $minute = null, $second = null,
  114. $month = null, $day = null, $year = null)
  115. {
  116. return MDB2_Date::unix2Mdbstamp(mktime($hour, $minute, $second, $month, $day, $year, -1));
  117. }
  118. // }}}
  119. // {{{ unix2Mdbstamp()
  120. /**
  121. * convert a unix timestamp into a MDB2 timestamp
  122. *
  123. * @param int a valid unix timestamp
  124. *
  125. * @return string a valid MDB2 timestamp
  126. * @access public
  127. */
  128. public static function unix2Mdbstamp($unix_timestamp)
  129. {
  130. return date('Y-m-d H:i:s', $unix_timestamp);
  131. }
  132. // }}}
  133. // {{{ mdbstamp2Unix()
  134. /**
  135. * convert a MDB2 timestamp into a unix timestamp
  136. *
  137. * @param int a valid MDB2 timestamp
  138. * @return string unix timestamp with the time stored in the MDB2 format
  139. *
  140. * @access public
  141. */
  142. public static function mdbstamp2Unix($mdb_timestamp)
  143. {
  144. $arr = MDB2_Date::mdbstamp2Date($mdb_timestamp);
  145. return mktime($arr['hour'], $arr['minute'], $arr['second'], $arr['month'], $arr['day'], $arr['year'], -1);
  146. }
  147. // }}}
  148. // {{{ mdbstamp2Date()
  149. /**
  150. * convert a MDB2 timestamp into an array containing all
  151. * values necessary to pass to php's date() function
  152. *
  153. * @param int a valid MDB2 timestamp
  154. *
  155. * @return array with the time split
  156. * @access public
  157. */
  158. public static function mdbstamp2Date($mdb_timestamp)
  159. {
  160. list($arr['year'], $arr['month'], $arr['day'], $arr['hour'], $arr['minute'], $arr['second']) =
  161. sscanf($mdb_timestamp, "%04u-%02u-%02u %02u:%02u:%02u");
  162. return $arr;
  163. }
  164. // }}}
  165. }
  166. ?>