How to get formatted datetime value from database

hao111

The time field in the mysql database table is of the datetime type. Use the date () function to obtain the time: $ regtime = date ("Y-m-d H: n: s"). Now I need to display only Y-m-d when outputting. How to format the output?

獠牙精英

echo date ("Y-m-d", strtotime ($ regtime));
Why not save it as a Unix timestamp?

hao111

thank you very much. Thanks for reminding, I will use timestamp in the future.