在sql中获取当前日期

Question

in the databse i have the format of the date like 'yyyy-mm-dd'.

how can i fetch the current date in this format? and then if i want to calculate the date after 1 week how can i do that.

thanxx in advance. Using php and mysql.

Answer 1

You don't need to use MySQL to fetch the date if you just want to know the current date in PHP. You can use PHP's date function:

$current_date = date('Y-m-d');

If you want the date one week from now, use strtotime:

$current_date = date('Y-m-d', strtotime('+1 week'));