1

I'm using this function to be able to retrieve several data, from outside the Loop:

function get_post_data($postId) {
 global $wpdb;
 return $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE ID=$postId");
}

... and then, this to display the date a post was published:

<?php 
global $wp_query;
global $thePostID;
$thePostID = $wp_query->post->ID;
$data = get_post_data($thePostID);
echo $data[0]->post_date;
?>

wich displays something like "2010-06-14 22:36:03" in my sidebar, but I'd like to format it like just "June, 2010"

Can it be done?

2
  • 2
    Not related to your question, but check out get_post() function that is native and more reliable way to retrieve single post's data.
    – Rarst
    Commented Nov 17, 2010 at 10:42
  • Agree with Rarst, why create a function for it when one exists already.. use get_post() or even get_posts() with posts_per_page set to 1 and nopaging set to true (it offers a little more than the singular counterpart).
    – t31os
    Commented Nov 17, 2010 at 15:10

1 Answer 1

7

I'm using something like this:

date('F, Y', strtotime($data[0]->post_date));
1
  • Thanks!To clarify for the readers, it worked when "echoed" it Commented Nov 17, 2010 at 4:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.