time formatting

narf

im trying to format a time that im pulling from a mysql time field heres the code im using:

$newtime = date("g:ma",$row[2]);

the $row[2] is the time record that im yanking out...i'm trying to format it just hour:minuteam/pm. i think ive tried just about everything and now im going insane...thankers

Bunkermaster

hmmm if DB is mysql the default query output format is YYYY-MM-DD HH:MM:SS. If you wanna formatthis string use regexp to break it down into parts that will fit in mktime...

ereg( "([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})$", $dateInput, $dateSplit )
date( "g:ma" , mktime ($dateSplit[4],$dateSplit[5],$dateSplit[6], $dateSplit[2] , $dateSplit[3] , $dateSplit[1] ) );

bernouli

try this

$time= split(":",$row[2]);
$newtime = date("g:ia",mktime($time[0],$time[1],$time[2])); 
echo $newtime;

Bunkermaster

argh time field du'h!

ok nm my answer and use bernouli's...

/me slaps himself into awake mode

COFFEE!

narf

i think there must be a problem with the PHP on my server...i tried your fixes and for every one it echos out 12:00am...hmmm...now im even more insane...thanks anyways

-narf

bernouli

try to echo out what Row[2] suppose to be

narf

know what bernouli...your solution did work for me...when you tol dme to check my row[2] output it looked all screwy...its cause i had left something in from all my experimentation on trying to get it to work...once i took that out it worked wonderfully....thank you thank you thank you....no more monkey on my back...no sireeee

YAY! :o]