change time format inside of query

[mohammad6006]

Originally Posted by kh99

You would either have to figure out how to use FROM_UNIXTIME() in the query, or else write a loop to read each row from the user table, use vbdate to convert, then do a separate INSERT for each.

I forgot that vbdate handles the timezone conversion based on a user's selecte timezone. Do you want the times to be converted for each user's timezone, or just for your own?

that is not important

I created a table with 3 columns : userid, dateline, date

I could select userid and lastactivity from "user" table and insert to userid and dateline in this table

but i want to convert lastactivity to Y-m-d format and insert into date column too