Unix TimeStamp to String

[astralprojection 35]

I had been looking to convert this time stamp to string format like

   

set .@unban_time,1460968293;

mes .@unban_time     //  but at string format below like

 

gettimestr("%Y-%m-%d %H:%M:%S",21) so that i can export to sql query.

 

Can you help?

 

Thank you

 

 

[Cretino 48]

Try this:

 

.@unban_time = 1460968293;
query_sql "SELECT FROM_UNIXTIME('"+.@unban_time+"', '%Y-%e-%d %H:%i:%s')", .@format$;
mes .@format$;
close;

[astralprojection 35]

it did good.  thank you sir.