http://qs321.pair.com?node_id=675475


in reply to Attack of the killer timestamps

I had considered trying to let Sybase handle all the time-stuff
Personally that's what I might do, using the T-SQL dateadd() call, something like
select ... from ... where the_date between dateadd(ss, -$seconds, $start_date) and dateadd(ss, $seconds, $end_date)
(using placeholders of course, $var used here for illustration purposes)

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
    Thanks for pointing that out - it might make the task a lot easier.