The Oracle database has this wonderfully rich data type called TIMESTAMP WITH LOCAL TIME ZONE. The elegance of this data type is that the value stored in this column will be displayed in the user's current database session time zone. Having written a PL/SQL package to do time zone conversion, it is a non-trival exercise to develop this type of functionality let alone maintain it. Wouldn't it be great if we could put this burden of maintaining constantly evolving time zone rules and daylight saving time dates on the database? Well, you get this for free with TIMESTAMP WITH LOCAL TIME ZONE.
Release Date: 31-Jan-11
Duration: -
Credited To: David Peake
No Flash Plugin Needed
14-Jul-11
-
19-Feb-11
07-Feb-11
good
Visit the Full Site | About Oracle | Contact Us | Terms of Use