Re: International Date Functionality

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/12/18
Message-ID: <34995B12.203F@charlie.cns.iit.edu>#1/1

Scott Thompson wrote:
>
> How do people deal with international time differences within the same
> database. If I have a database on a server that can be updated from
> multiple client locations in different countries and/or time zones, what
> is the best way to deal with this.
>
> I have worked with other RDBMS products that support this directly and I
> would prefer not to have to write application code to handle this;
> however, I am under the impression, from past experience, that Oracle
> does not really support this very well, i.e. I have to do date and time
> translations manually within client applications.
>
> Any brilliance in this area would be appreciated.
>
> --
> Scott Thompson
> sft @ lucent . com

---

Hi,
Oracle has one beatiful function called NEW_TIME, which will take care of timezones (NOT all the international time zones but GMT)

SELECT NEW_TIME(SYSDATE,'CST', GMT') FROM DUAL; (CENTRAL STANDARD TIME TO GMT) AMARENDRA

-- 
******************************************************************************
AMARENDRA B NETTEM			5039 N E River Road, Apt. 1A
Oracle Certified DBA (OCP)		NORRIDGE, IL 60656
Whittman-Hart Inc., 
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.  

Ph.No. (708) 583 9870 (H)  
       (312) 913 6758 (W)  

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************************
Opinions are mine and do not necessarily reflect those of Whittman-hart
Inc.

Received on Thu Dec 18 1997 - 00:00:00 CST