Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Attack of the killer timestamps

by mpeppler (Vicar)
on Mar 21, 2008 at 17:12 UTC ( #675475=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://675475]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2020-10-30 13:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My favourite web site is:












    Results (279 votes). Check out past polls.

    Notices?