Hi, I'm stuck with converting a server date within an sql query - here is the query -

Select
`Order Number`.order_modified AS Date,

`Order Number`.order_full_price As Amount,
xdfg_hikashop_product.product_name As `Order Details`,
`Order product`.code_photo,
`Order Number`.order_invoice_number As Invoice
From
xdfg_hikashop_order `Order Number` Inner Join
xdfg_hikashop_order_product `Order product` On `Order Number`.order_id =
`Order product`.order_id Inner Join
xdfg_hikashop_product On `Order product`.product_id =
xdfg_hikashop_product.product_id Inner Join
xdfg_hikashop_user On xdfg_hikashop_user.user_id =
`Order Number`.order_user_id Inner Join
xdfg_users Users On Users.id = xdfg_hikashop_user.user_cms_id
Where
Users.id = {$userid}

the order_modified query returns a date like this - 1358032117 which I'm guessing is the server time format. How can I convert this within the statement to something like 16th January 2013 ??

Have been trawling the internet for several hours to find a solution!
Many thanks,

Derek

p.s. wonderful module, solved a whole heap of issues for me!

Got it!


FROM_UNIXTIME(`Order Number`.order_modified,'%D %M %Y') As Date,