<script>document.write(new Date().getFullYear())</script>
Showing posts with label DATE/TIME. Show all posts
Showing posts with label DATE/TIME. Show all posts
Thursday, February 13, 2014
Friday, February 1, 2013
Select Query Last Month Unix Timestamp In MySQL
Change [fields], [table] and [datefield] to suite your needs.
If your dates are not stored as Unix timestamps then you can remove the "from_unixtime" function wrapping [datefield]
If your dates are not stored as Unix timestamps then you can remove the "from_unixtime" function wrapping [datefield]
select [fields] from [table] where from_unixtime([datefield]) >= DATE_SUB(NOW(), INTERVAL 1 MONTH);
Monday, February 8, 2010
Twelve month historical reference (month/year) (rolling)
<?php
$m = date('m');
$y = date('Y');
for ($i = 1; $i < 12; ++$i) {
$d[] = date($format, mktime(12, 12, 12, $m-$i, 1, $y));
}
$d = array_reverse($d);
array_unshift($d, date($format));
/*
WHEN YOU PARSE THE ARRAY YOULL GET A LISTING OF MONTHS (JAN-DEC)
WHERE BY THE CURRENT MONTH BACK TO JAN ARE OF THE CURRENT YEAR
AND WHEREBY THE NEXT MONTH TO DEC ARE OF THE PREVIOUS YEAR
E.G
TODAY: JAN 2010
OUTPUT:
Month=1&Year=2010
Month=2&Year=2009
Month=3&Year=2009
Month=4&Year=2009
Month=5&Year=2009
Month=6&Year=2009
Month=7&Year=2009
Month=8&Year=2009
Month=9&Year=2009
Month=10&Year=2009
Month=11&Year=2009
Month=12&Year=2009
E.G
TODAY: NOV 2010
OUTPUT:
Month=11&Year=2010
Month=12&Year=2009
Month=1&Year=2010
Month=2&Year=2010
Month=3&Year=2010
Month=4&Year=2010
Month=5&Year=2010
Month=6&Year=2010
Month=7&Year=2010
Month=8&Year=2010
Month=9&Year=2010
Month=10&Year=2010
*/
?>
Friday, January 29, 2010
Twelve month historical reference (month/year) (non-rolling)
<?php
$format = "\M\o\\n\\t\h=n&\a\m\p;\Y\e\a\\r=Y"; //OUTPUT FORMAT
$m = date('m');
$y = date('Y');
$dates = array();
for ($i = 1; $i < 13; ++$i) {
if ($i == $m + 1)
--$y;
$dates[] = date($format, mktime(12, 0, 0, $i, 1, $y));
}
/*
WHEN YOU PARSE THE ARRAY YOULL GET A LISTING OF MONTHS (JAN-DEC)
WHERE BY THE CURRENT MONTH BACK TO JAN ARE OF THE CURRENT YEAR
AND WHEREBY THE NEXT MONTH TO DEC ARE OF THE PREVIOUS YEAR
E.G
TODAY: JAN 2010
OUTPUT:
Month=1&Year=2010
Month=2&Year=2009
Month=3&Year=2009
Month=4&Year=2009
Month=5&Year=2009
Month=6&Year=2009
Month=7&Year=2009
Month=8&Year=2009
Month=9&Year=2009
Month=10&Year=2009
Month=11&Year=2009
Month=12&Year=2009
E.G
TODAY: NOV 2010
OUTPUT:
Month=1&Year=2010
Month=2&Year=2010
Month=3&Year=2010
Month=4&Year=2010
Month=5&Year=2010
Month=6&Year=2010
Month=7&Year=2010
Month=8&Year=2010
Month=9&Year=2010
Month=10&Year=2010
Month=11&Year=2010
Month=12&Year=2009
*/
?>
Subscribe to:
Posts (Atom)