Re: How to find Timezone in Pl/SQL?

Risudi wrote in message <20000321152807.01950.00007795_at_ng-dc1.aol.com>...
>In PL/SQL, is their a way to retreive the 'timezone' of the
>machine the database is stored on.
>
>(version 8.1.5 on a Sun Sparc box)
>
>Rick
>risudi_at_aol.com
>
>

Hook the PL/SQL call to a Java Stored Procedure (something like this)

import java.util.TimeZone;

class LocalTimeZone {

   String ID = System.getProperty("user.timezone"); ...... Received on Tue Mar 21 2000 - 00:00:00 CST