Doubts about converting dates

[Javier Pérez]

Hello good afternoon....
I'm trying to convert the int date to datetime from the dateline column of my post table, does anyone have idea or could you help me with this? I'm doing a sql query that returns me the dates sorted but with the datetime format

 

[Mike]

As you're referring to your post table, that would imply you're already running XenForo. Please associate your forum account with your customer account so you can post in the support forums.