Pada contoh berikut ini Server Oracle (GMT+07:00), sedangkan Client (GMT+10:00)
select to_char(localtimestamp,'DD-MM-YYYY HH24:MI:SS') local_time,
to_char(systimestamp,'DD-MM-YYYY HH24:MI:SS') db_time,
dbtimezone, sessiontimezone
from dual;
LOCAL_TIME DB_TIME DBTIMEZONE SESSIONTIMEZONE
-------------------- --------------------- ------------- ------------------
23-01-2007 16:13:41 23-01-2007 13:13:41 +07:00 +10:00
Bisa coba dengan mengubah-ubah setting time pada Client (misalnya MS Windows).
Setelah mengubah waktu pada client, harus disconnect dulu dari database dan
connect kembali.
Semoga membantu.
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: fata hudaya
To: [email protected] ; [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2007 12:58 PM
Subject: [indo-oracle] Function Time Zone
Dear Masters & Friends,....
Bagaimana caranya menset waktu sesuai dengan wilayahnya, jadi bukan waktu
server. Contoh : di Indonesia kan dibagi menjadi 3 bagian waktu : WIB (+7),
WITA (+8), WIT (+9).
Semoga teman2 bisa membantu.
Thanx n Best Regards,
Fata Hudaya,
+628567143271
[EMAIL PROTECTED]
__________________________________________________________
All New Yahoo! Mail - Tired of unwanted email come-ons? Let our SpamGuard
protect you. http://uk.docs.yahoo.com/nowyoucan.html
[Non-text portions of this message have been removed]
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.0.410 / Virus Database: 268.17.5/645 - Release Date: 1/22/2007
[Non-text portions of this message have been removed]
