By jeditdog on

I select a date in a query:
select n.nid, n.title, n.changed
from term_node t, node n
where n.nid = t.nid
and tid in (---);

It currently just returns a number and MySQL's date formatting doesn't work to format it. How do I get a formatted date from this so that I can show my users when node was last updated?

thanks

⋅ Categories: Drupal 5.x

Comments

jeditdog’s picture

jeditdog commented

I explored the node.module real fast and saw the php function mktime very quickly.

I thought about checking it to begin with, but didn't. Please feel free to skip this question, it is solved.

-------------
The main man of MMC :)