Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: NOW SQL portability

by herveus (Parson)
on Dec 22, 2009 at 12:31 UTC ( #813862=note: print w/ replies, xml ) Need Help??


in reply to NOW SQL portability

Howdy!

SQL portability can be a real red herring, given the variations found across the range of implementations. You have to ask yourself how many different flavors of SQL you want to try to support. You may have no choice but to have slightly different code bases for each flavor.

I don't know if there is a portable way for getting "today's date". Oracle uses "sysdate"; Informix uses "current...". MSSQL and Sybase may actually use the same function, given their common heritage.

yours,
Michael


Comment on Re: NOW SQL portability

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (8)
As of 2014-08-28 10:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (259 votes), past polls