Kalau A dan B berbeda pc dan OS nya Windows bisa juga set parameternya di
environment variable
name = nls_date_format
value = dd-mm-yyyy --(untuk A)
yyyy-mm-dd --(untuk B)
rgds,
Awal
----- Original Message -----
From: Firman H.M.
To: [email protected]
Sent: Thursday, January 25, 2007 10:26 AM
Subject: Re: [indo-oracle] ubah format date di oracle
create or replace trigger
different_date
AFTER LOGON ON DATABASE
BEGIN
if user='A' then
alter session set nls_date_format = 'dd-mm-yyyy';
else
alter session set nls_date_format = 'yyyy-mm-dd';
end if;
END;
/
CMIIW
2007/1/25, Oscar Wilyanto <[EMAIL PROTECTED]>:
>
> Dear Masters,
>
> Mau tanya, apakah di Oracle tipe data 'date' bisa di pre-set formatnya?
>
> jadi misalnya di database A format tanggalnya 25-12-2006, sedangkan di
> database B format tanggalnya bisa 2006-12-25.
>
> Kalau ya, bagaimana cara men-setnya?
>
> Thanks,
> Oscar
>
> ----------------------------------------------------------
> This message contains confidential information and is intended only for
> the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete
> this e-mail from your system. E-mail transmission cannot be guaranteed to
> be
> secure or error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. MKD Group
> therefore
> does not accept liability for any errors or omissions in the contents of
> this
> message, which arise as a result of e-mail transmission. If verification
> is
> required please request a hard-copy version.
>
> MKD Group, www.mkdgroup.com
> ----------------------------------------------------------
>
> [Non-text portions of this message have been removed]
>
>
>
--
Firman HM
PT. Xsis Mitra Utama
Graha BIP 7th Floor Jl. Jend. Gatot Subroto Kav.23 Jakarta 12930 -
Indonesia
Tel : +62-21-5210565 Hotline : +62-21-5210564 Fax : +62-21-5229777
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
