mysql/php date and time help

[phence]

How can you first of all get the current server time and date($cur_date)?

How can you change the server time and date into a mysql datatype datetime format? and keep the time & date from advancing?

I am trying to get a future date($od)... is this correct?

$period = 20;

$od = "SELECT date_add('$cur_date', INTERVAL $period DAY_SECOND)";

any input is appreicated

[malbera]

Read this !!
the manual is always the best place to start

[phence]

well ... i know how to get the server time like this:

$cur_time = "SELECT now()";

but is it the best way af getting it to do what i need to do?