Thanks for your reply.

I am using a block which shows the last five forum topics on my nuke homepage. The server is in the US and the post times are US times. I would like to show the time as local Australian time (usually GMT+15).

Here is the line of code:

$result3 = sql_query("SELECT poster_id, FROM_UNIXTIME(post_time,'%d %M %y at %h:%i %p') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id'", $dbi);