Date() not displaying all information

I have my site displaying times when news articles were edited last (if they were edited). I want it to show the date and time when it was edited However it is only showing the date and for time it is only showing 00:00. Here is the code:

My guess is either that your editing_date field is a date rather than a datetime field or that you're inserting dates with no time values into it if it's a datetime field. Select just the editing_date with no formatting and see what you get.

My editing_date field is a timestamp field

This has bitten me in the bum a number of times. You need to give your field an alias:



Wrapping a function around it effectively changes the column name for the purposes of the output.

That did not seem to fix the problem completely because it is now showing 13:00 instead of the correct time.

I have attached the actual file just incase

In the following code (starting at line 39):



you're invoking $article, which is the variable you're putting $news['article_text'] into, when it seems you should be invoking $news. Also, in your query, you'll need to give an alias to the posting_date field as well.

Thank you for pointing out the call to the wrong variable. However, it is now showing the posting date as 12/31/1969 and the editing date & time as 12/31/1969 18:59.

I have attached the updated file

if your date field is datetime then you can try this sorry i just skipped through the post but this works



the first one gets the date aspect of it formated in date time wed jan etch and the second gets the time as in 12:00:23 am etc.... put the code in your query and the date_field is your field that contains the date =]

It is a timestamp, not a datetime field

i just read up on it and it seems you can manipulate the timestamp using date_format
check here

I figured out the problem. I had it using the strtotime() function as well. That is what was screwing it up

Thank you for all your help guys