Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: calculate time(days)

by SageMusings (Beadle)
on Apr 04, 2002 at 20:05 UTC ( #156749=note: print w/replies, xml ) Need Help??


in reply to calculate time(days)

Fellow Perl disciple,

I have no idea what type of dates you are working with. Where I work, we use Julian calendar dates in our databases. I have developed a method for resolving the span of dates between to Julian dates. It took no thought and 13 lines of code.

Also, you are not going to implement such a function in SQL. Forget the database integration; it is just an abstraction layer.

I apologise for not including the code, I mentioned, but I am logging on today from an alien machine in an alien office. So far, no one has noticed my meditation robes or heard my chanting of Perl mantras.

Replies are listed 'Best First'.
Re: Re: calculate time(days)
by Aighearach (Initiate) on Apr 04, 2002 at 23:31 UTC
    I always code these things in either PL/SQL or PL/Perl, which both provide database integration, as they run inside the database server and not on the database client.
    --
    Snazzy tagline here

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (4)
As of 2022-11-30 04:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?