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. |
13 // | Redistribution and use in source and binary forms, with or without |
14 // | modification, are permitted provided that the following conditions |
17 // | Redistributions of source code must retain the above copyright |
18 // | notice, this list of conditions and the following disclaimer. |
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. |
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. |
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 // +----------------------------------------------------------------------+
45 // $Id: Date.php 327316 2012-08-27 15:17:02Z danielc $
51 * @author Lukas Smith <smith@pooteeweet.org>
55 * Several methods to convert the MDB2 native timestamp format (ISO based)
56 * to and from data structures that are convenient to worth with in side of php.
57 * For more complex date arithmetic please take a look at the Date package in PEAR
61 * @author Lukas Smith <smith@pooteeweet.org>
68 * return the current datetime
70 * @return string current datetime in the MDB2 format
73 public static function mdbNow()
75 return date('Y-m-d H:i:s');
82 * return the current date
84 * @return string current date in the MDB2 format
87 public static function mdbToday()
96 * return the current time
98 * @return string current time in the MDB2 format
101 public static function mdbTime()
103 return date('H:i:s');
107 // {{{ date2Mdbstamp()
110 * convert a date into a MDB2 timestamp
112 * @param int hour of the date
113 * @param int minute of the date
114 * @param int second of the date
115 * @param int month of the date
116 * @param int day of the date
117 * @param int year of the date
119 * @return string a valid MDB2 timestamp
122 public static function date2Mdbstamp($hour = null, $minute = null, $second = null,
123 $month = null, $day = null, $year = null)
125 return MDB2_Date::unix2Mdbstamp(mktime($hour, $minute, $second, $month, $day, $year, -1));
129 // {{{ unix2Mdbstamp()
132 * convert a unix timestamp into a MDB2 timestamp
134 * @param int a valid unix timestamp
136 * @return string a valid MDB2 timestamp
139 public static function unix2Mdbstamp($unix_timestamp)
141 return date('Y-m-d H:i:s', $unix_timestamp);
145 // {{{ mdbstamp2Unix()
148 * convert a MDB2 timestamp into a unix timestamp
150 * @param int a valid MDB2 timestamp
151 * @return string unix timestamp with the time stored in the MDB2 format
155 public static function mdbstamp2Unix($mdb_timestamp)
157 $arr = MDB2_Date::mdbstamp2Date($mdb_timestamp);
159 return mktime($arr['hour'], $arr['minute'], $arr['second'], $arr['month'], $arr['day'], $arr['year'], -1);
163 // {{{ mdbstamp2Date()
166 * convert a MDB2 timestamp into an array containing all
167 * values necessary to pass to php's date() function
169 * @param int a valid MDB2 timestamp
171 * @return array with the time split
174 public static function mdbstamp2Date($mdb_timestamp)
176 list($arr['year'], $arr['month'], $arr['day'], $arr['hour'], $arr['minute'], $arr['second']) =
177 sscanf($mdb_timestamp, "%04u-%02u-%02u %02u:%02u:%02u");