in reply to Attack of the killer timestamps
I had considered trying to let Sybase handle all the time-stuffPersonally that's what I might do, using the T-SQL dateadd() call, something like
(using placeholders of course, $var used here for illustration purposes)select ... from ... where the_date between dateadd(ss, -$seconds, $start_date) and dateadd(ss, $seconds, $end_date)
But then I'm really a database developer writing tons of SQL, these days... :-)
Michael
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Attack of the killer timestamps
by chexmix (Hermit) on Mar 21, 2008 at 18:20 UTC |
In Section
Seekers of Perl Wisdom