Date number

[goofaholix]

My application stores datetime as the number of seconds since 01-JAN-70 12:00 in an Oracle database.

I'd like to be able to calculate the number of seconds between the time of the transaction and midnight on the day the transaction is done.

Does anyone know how to convert a datetime to the number of seconds since 01-JAN-70 12:00 in pl-sql?

Thanks.

 

[r937]

perhaps you might want to ask this question in one of the oracle forums?

in the ANSI SQL forum, we don't usually deal with PL-SQL

r937.com | rudy.ca