Re: converting a UTC value into a local time value

Jana Lorbeer wrote:
>
> hi there,
> i have to storage and cumulate data from all over the world, which should be
> retrieved from all over the world arranged in the respective local time.
> Now I`m looking for a good advice to structure, arrange or cumulate these data
> that way I could easily draw out data for a special hour, day or month at a
> special local time.
> (Oracle fixed 'em in UTC = coordinated universal time.)
> tx
> jana
>
> ---------------------------------------------------------------
>
> Name: jana.lorbeer.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Jana Lorbeer

This may be a good starting point...

http://govt.oracle.com/~tkyte/Misc/CTime.html

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse