Date

[scott100]

Date is saved in mysql datebase.When printed from the database with this:

{$row['date']}

I get this result: 2008-12-31what i want to do is format that date so it looks neater so i need helpI tried this

$d=date('j F y', $row['date']);

but that prints out1 January 70for all my dates How can print my date formated?

[Little Goat]

well, I think that is where the unix timestamp (or whatever it's called) goes from. it looks like the date() function doesn't recognize the format you are using.

[scott100]

well, I think that is where the unix timestamp (or whatever it's called) goes from.  it looks like the date() function doesn't recognize the format you are using.

<{POST_SNAPBACK}>

Yeah apparently they don't go together, i found this on another forum and it works, maybe it will help someone else

//Remove the '-' from the standar MySQL sate formatlist($Year,$Month,$Day) = split('-',$row['date']); //Create a UNIX style timestamp from the result$stampeddate = mktime(12,0,0,$Month,$Day,$Year); $realDate = date("jS F Y",$stampeddate);

[justsomeguy]

Probably break it up yourself, and either create a new date object if you want to get more info than what you already have (day of the week or month name or whatever), or just rearrange the 3 parts. $chunks = explode("-", $row['date']);list($year, $month, $day) = $chunks;$d = getdate(mktime(0, 0, 0, $month, $day, $year));Now you have an array of the things available through getdate, like month name or day name.

[justsomeguy]

Holy crap, that's almost exactly what I did. But yeah, it's for reasons like this that I only store my dates and times in Unix timestamp format.

[scott100]

Holy crap, that's almost exactly what I did.  But yeah, it's for reasons like this that I only store my dates and times in Unix timestamp format.

<{POST_SNAPBACK}>

Nearly spot on How do i save them as unix timestamp format, i am using now() to timestamp everything logged in the db

[justsomeguy]

You can use mktime to convert to a timestamp, use time to get the current one, and use getdate to convert from a timestamp into an array with more info.http://www.php.net/manual/en/function.mktime.phphttp://www.php.net/manual/en/function.time.phphttp://www.php.net/manual/en/function.getdate.phpYour database fields can just be normal integers, they don't need to be long or float or anything.