Converting repository dates!!

[system]

have a look at this :

120×120 10.4 KB

How can I convert repository dates into something I can understand? The BusinessObjects repository dates are in UTC format. Depending on your database, you need different functions to translate from this value to a date/time. The definition of a UTC value is the number of seconds since midnight on December 15, 1970. For Oracle, for example, you can simply add the number of seconds divided by the number of seconds in a day, as in: to_date('15-DEC-1970','DD-MON-YYYY') + (m_actor_n_lad/…

---

bernard timbal (BOB member since 2003-05-26)