[Dbix-class] complex db function

[rahed]

Hi,

I'd like to use a database function from SQLite which should produce
this select:

select id,round((julianday(date2) - julianday(date1))*86400) as 'tdiff'
from mytable;

I know I can search the resultset and specify the source for my column
value as a function but don't know how to use the above more complex
query with several functions.

e.g. $rs->search(undef,{
select=>['id',{somefunction=>'date2'}],
as => [('id',lastdate')],
});

Any suggestions?

Thank you.

-- 
Radek