hi
i'm using abodb but this query doesn't print anything.can u suggest me why this doesn't work or is there any other alrternative for this same functionality.
$callduration=$conn->Execute("select sum(UnixTimeStamp(Call_log_end_time) - UnixTimestamp Call_log_date_and_time_called)) as duration from call_log where Call_log_appt_date_time>='2002-04-2002 00:00:00' and Call_log_appt_date_time<='2002-04-2002 23:59:59' and Call_log_user_id='bob' and Call_log_call_status='success' ");
$mysum=$callduration->fields['duration'];
echo $callduration->fields['duration'];
echo $mysum,"mysum value";
in Mysql it is unix_timestamp ,it works fine but in adodb it is unixtimestamp .
plz help me
