Re: Portable SQL to compute a date difference in seconds???

Understood... and confirms my suspicion - no general solution possible
even for something as simple, common and basic as subtracting 2
dates...
The level of standardisation in SQL is below what I expected. :-(

The problem actually is much bigger - there are many architectural
differences among various DB and these are much more important than
just some syntactic problems.
If you don't care about them then either
1) you are creating application that won't work correctly on at least
some of your DB's
2) you are using the very very basic features of each DB and so your
customers will waste much $$ gathering licences for thousands of bucks
and using only 1% of features they bought

OK there is also third way - you are creating an app that has unique
software level for each DB but then your app is very big, very
expensive and you have developed it over many years :)

An variation on the comment from Gints:
Time for the DBMS vendors to understand that their lack of
standardisation is costing people a lot of time and effort.

There are many cars around an you cannot simply get engine from
Ferrari and put it into Trabant. Each model is predicted for different
needs and resources, each is manufactured by different company,
developed by different people thinking differently, each have his own
history, they'll never be equal.
And that's why we have alternatives, that's why the life is
interesting :)

Gints Plivna
http://www.gplivna.eu

.

Quantcast