« Backbase Combobox + PHP
Launching IE7 without extensions »
MySQL timestamp format to human readable

Ok, I have no idea where this originally came from but its been very useful the past few years for converting the standard "0000-00-00 00:00:00" format into something useable (and that the client accepts):

function mysql_timestamp_to_human($dt){
     $yr=strval(substr($dt,0,4));
     $mo=strval(substr($dt,4,2));
     $da=strval(substr($dt,6,2));
     $hr=strval(substr($dt,8,2));
     $mi=strval(substr($dt,10,2));
     //$se=strval(substr($dt,12,2));
       
     return date("m/d/Y H:i", mktime ($hr,$mi,0,$mo,$da,$yr))." GMT";
}
 
pdavies | MySQL | 18 June, 11:03am
Trackback URI: http://www.dot-commers.co.uk/index.php/trackback/7
titan poker bonus code vscx: titan poker bonus code / 24 November, 6:34pm
titan poker bonus code
code bonus titan poker vscx: code bonus titan poker / 25 November, 6:35pm
code bonus titan poker
everest poker hume: everest poker / 29 November, 10:06am
everest poker
slotmaschinen kvbe: slotmaschinen / 5 December, 11:15pm
slotmaschinen
avafx zbhz: avafx / 8 December, 2:35pm
avafx
forex online nbfr: Forex online / 8 December, 6:39pm
Forex online
casino tropez khuh: casino tropez / 12 December, 1:39pm
casino tropez
titan poker bonus code wxbq: titan poker bonus code / 16 December, 1:18pm
titan poker bonus code
pacific poker edkj: pacific poker / 21 December, 10:48am
pacific poker
avafx ikfo: avafx / 23 December, 10:31am
avafx
nice article zzqt: bonus gratis europa casino / 27 December, 9:55am
bonus gratis europa casino
europa casino dzxx: europa casino / 30 December, 3:27pm
europa casino
pocker stars tcjt: pocker stars / 30 December, 4:29pm
pocker stars
spiel online blackjack fgax: spiel online blackjack / 30 December, 5:29pm
spiel online blackjack
casino blackjack gpmh: casino blackjack / 30 December, 6:29pm
casino blackjack
online craps jsdc: online craps / 30 December, 7:29pm
online craps
play free blackjack pqqi: play free blackjack / 30 December, 8:29pm
play free blackjack
gratis baccarat spil mdwb: gratis baccarat spil / 30 December, 9:29pm
gratis baccarat spil
speel roulette doqj: speel roulette / 30 December, 10:27pm
speel roulette
spill gratis blackjack pgxy: spill gratis blackjack / 30 December, 11:24pm
spill gratis blackjack
spela gratis blackjack vkhv: spela gratis blackjack / 31 December, 12:20am
spela gratis blackjack
code bonus poker 770 tqdi: code bonus poker770 / 3 January, 2:08pm
code bonus poker770
اسعار العملات اليوم xvfb: اسعار العملات اليوم / 3 January, 5:17pm
اسعار العملات اليوم
forex online tpcc: Forex online / 5 January, 10:19am
Forex online
europa casino eato: europa casino / 5 January, 11:41am
europa casino
telecharger everest poker tpwj: telecharger everest poker / 5 January, 12:50pm
telecharger everest poker

Leave a Comment









Comment XML feeds: RSS | Atom

Category Cloud

Link Dump Tag Cloud