title: Converting Unix timestamp to actual Date and time
body: <p>Is there any sql command which I can insert into the stated query so I can convert the timestamp. Although it could be done separately which I have seen so far but I am trying to find something which I can add to the stated query as that would be helpful because I am using other queries to retrieve the data as well. If you any other questions please do mention. Addition: rating_timestamp contains both time and date. </p>
  
  <pre><code>SELECT rating_id,
         rating_postid,
         rating_posttitle,
         rating_rating,
         rating_timestamp,
         rating_username,
         rating_userid
  FROM wp_ratings;
  </code></pre>