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
Comment on
Re: Converting dates
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. :-)
[reply]
In Section
Seekers of Perl Wisdom