SELECT current_date + interval '3 days' as Saturday
saturday
-------------
2006-03-04 00:00:00
But in MS-SQL, it's
SELECT dateadd(d, 3, getdate()) as Saturday
Saturday
--------------
2006-03-04 14:16:19.060
Should SA even have a role in trying to "paper over" these kinds of
differences?
Does it make sense to develop a set of function abstractions that
would work across these databases?
I think that for base operations on standard types covered by the
ansi standard such as dates it would be interesting to
have abstractions that would map to concrete operations on non-ansi
dbs. (like it already does with string concatenations)
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
