change time format inside of query

[mohammad6006]

Originally Posted by kh99

I think you want to use the mysql function FROM_UNIXTIME(). Here's the documentation: http://dev.mysql.com/doc/refman/5.5/..._from-unixtime

vbdate('Y-m-d', lastactivity) work out of the query

for example if I fetch query and store in variable like: $visitor[lastactivity] and then
vbdate('Y-m-d', $visitor[lastactivity]) was working

my problem is that i can not use it in the query