[SOLVED] php Date

[tekrscom]

I feel very retarded right now because I'm asking one of those questions that I asked several years ago... all over again... but anyway...

 

So... I am trying to print a date from a MySQL 5.0.81 database in a DateTime format using PHP 5.2.5...

 

When I echo the raw date, it is correct, but when I attempt any notion of using date(), forget it, nothing works...

 

I was originally trying this...

date('D M d, Y h:i a', $row['ThreadDatePosted'])

 

But during testing I simplified it down to just Y-m-d...

    $ThreadDatePosted = $row['ThreadDatePosted'];
    echo $ThreadDatePosted;
    //$ThreadDatePosted = date('D M d, Y h:i a', $row['ThreadDatePosted']);
    $ThreadDatePosted = date('Y-m-d', $ThreadDatePosted);

 

Thinking that I was going mad, I started pouring over articles again about using php w/mysql datetime, but this is still what I was coming up with... Can someone please enlighten me?

[corbin]

Have you echoed out $row['...']?

 

 

Chances are, it's a string representation of the DATETIME field, and the date() function takes an integer representing a Unix timestamp as its second argument.

 

 

That means at some point you need to convert the text to a unix timestamp.

 

You can either use strtotime(), or (and this is the way I suggest), you could use UNIX_TIMESTAMP(ThreadDatePosted) as uThreadDatePosted

[PFMaBiSmAd]

The second parameter in the date() function is a Unix Timestamp -

Description

string date ( string $format [, int $timestamp ] )

timestamp

The optional timestamp parameter is an integer Unix timestamp that defaults to the current local time if a timestamp is not given.

 

If that is not what you are putting in it, the code you are using won't work will it?

 

If your database column is a DATE or DATETIME data type, why not just use the mysql DATE_FORMAT() function directly in your select query to format it any way you want - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

 

[tekrscom]

Have you echoed out $row['...']?

 

 

Chances are, it's a string representation of the DATETIME field, and the date() function takes an integer representing a Unix timestamp as its second argument.

 

 

That means at some point you need to convert the text to a unix timestamp.

 

You can either use strtotime(), or (and this is the way I suggest), you could use UNIX_TIMESTAMP(ThreadDatePosted) as uThreadDatePosted

 

Yes, I did try to just echo out the $row['...']... Same result...

 

Could you give a small example of how UNIX_TIMESTAMP(ThreadDatePosted) as uThreadDatePosted would work... I tried this... but it didn't work...

$ThreadDatePosted = date('Y-m-d', UNIX_TIMESTAMP($ThreadDatePosted));

[tekrscom]

Ok, got it

 

$query = "SELECT ForumThreads.*, UNIX_TIMESTAMP(ForumThreads.ThreadDatePosted) as uThreadDatePosted, Users.Username FROM ForumThreads LEFT JOIN Users ON ForumThreads.PosterUserID = Users.UserID WHERE TopicID = '$_GET[TopicID]'"; 

 

Yeah!!! Thanks guys