mysql now()

[gilby]

For a mod I am working on I want to get the result of the mysql now() function.
I don't want the server or php version it has to be the mysql now() version.

In other words can a mysql expert show me a simple way in a zen cart environment to write a simple and efficient "do nothing" query that returns the value of mysql now() to a variable. I know I can save it to database field and then read it but I am looking for a more efficient way.

Cheers Gilby

[DrByte]

$sql = "select now() as date from address_book limit 1";
$result = $db->Execute($sql);

$database_server_date_timte = $result->fields['date']; 

[gilby]

$sql = "select now() as date from address_book limit 1";
$result = $db->Execute($sql);

$database_server_date_timte = $result->fields['date']; 

Thanks for the code Dr Byte. Simplified it slightly and the following works like a charm.

$result = $db->Execute("select now() as date"); 
$database_server_date_time = $result->fields['date'];