In my last post I provided some Oracle PL/SQL functions for dealing with Oracle DATEs and Unix timestamps. After using these functions in an application that is executed via Oracle Application Server I discovered a problem. In short, if the executing environment doesn’t supply any time zone information then the part of the functions that [...]
Archive of entries posted on February 2012
Oracle, Daylight Saving Time, And Unix Timestamps
Notice: the functions in this post are fragile. See Oracle And Unix Timestamps Revisited for a more robust implementation. If ever there was a combination to make you hate developing web applications against an Oracle database, it’s the one defined in the title of this post. Let’s see: Unix timestamps are used in a lot [...]
