in reply to Converting dates

Easy,
Just use two other columns in the query itself,
ie
my $query = "SELECT DISTINCT ID,unix_timestamp(tUpdate) as t,unix_time +stamp(tEnter) as p,tUpdate, tEnter from ini_Rate where tUpdate > tEnter limit 5 ";

Thanks
Abhi

Replies are listed 'Best First'.
Re^2: Converting dates
by denzil_cactus (Sexton) on Aug 12, 2008 at 09:04 UTC
    Thanks Abhi!! It is the best solution. :-)