[Resolved] [Resolved] Date format

zzz

Hi,

I need to grab a date from my db and display it in a human format.

I know I could do the date format like this:

$date = date("F j, Y");

the only problem this would be a current time.

Since I retrieve the date from db like this:

$date = $tbl->date;

how would I combine the two?

bubblenut

What is the format of the date you're getting from the database? If it's a UNIX TIMESTAMP then you can do this

$date = $tbl->date;
$date = date("F j, Y", $date);

HTH
Bubble

zzz

Yes, it is a Unix datetime stamp 0000-00-00 00:00:00

The script did not work for some reason. It displays the odd date:
December 31, 1969 ...

bubblenut

No, it's not a unix datestamp, it's a MySQL datestamp. A unix datestamp is the numberof seconds which have elapsed since the first epoch (1st Jan 1970). If you're using MySQL you can select it out of the database with the unix_timstamp(date)(down the bottom) function which will convert it into a unix timestamp, otherwise you can use php's [man]strtotime()[/man]. Doing it withing MySQL would be preferable.

HTH
Bubble

zzz

I looked at both but just as lost as ever...

zapa

not sure if i undetstand you question right...
but how about....

// Find day of date in a week name of day
$date = "07/04/2004";
$ts = strtotime($date);
echo date('F d, Y',$ts) . " falls on a " . date('l',$ts);

TheDefender

Yeah Zapa, that's what he's looking for...

$variable = strtotime(0000-00-00 00:00:00);
Will work just fine....

Example...

$starttime = strtotime("2004-07-04 06:00:00");
echo $starttime;
// Outputs: 1088935200

You can then use that UNIX timestamp and convert it to whatever using the date function:

$endresult = date("l, F jS, Y g:i:s A", $starttime);
echo $endresult;
// Outputs: Sunday, July 4th, 2004 6:00:00 AM

zzz

This was the missing link. Works just as I needed it!