Coba di set pakai NLS_DATE_FORMAT di level system. SQL> conn / as sysdba SQL> ALTER SYSTEM SET NLS_DATE_FORMAT = 'DD-MM-YYYY'; atau SQL> ALTER SYSTEM SET NLS_DATE_FORMAT = 'YYYY-MM-DD';
Bowo --- In [email protected], ageng setia <[EMAIL PROTECTED]> wrote: > > Hallo Semua > Coba pakai perintah ini Mas TO_DATE('Field','Format-nya') > Siapa tau membantu Mas dan harap maklum klo nggak membantu soalnya newbie ^_^. > Semoga berhasil Mas. > Sukses Untuk Kita Semua. > > Best regards > ag3ng > > JUST BRAVO-IT > > ----- Original Message ---- > From: Oscar Wilyanto <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, January 25, 2007 9:19:59 AM > Subject: [indo-oracle] ubah format date di oracle > > > > > > > > > > > > > > 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] > > > > > > > > > > > > > > > <!-- > > #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans- serif;} > #ygrp-mlmsg table {font-size:inherit;font:100%;} > #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height:1.22em;} > #ygrp-text{ > font-family:Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0; > } > #ygrp-tpmsgs{ > font-family:Arial; > clear:both; > } > #ygrp-vitnav{ > padding-top:10px; > font-family:Verdana; > font-size:77%; > margin:0; > } > #ygrp-vitnav a{ > padding:0 1px; > } > #ygrp-actbar{ > clear:both; > margin:25px 0; > white-space:nowrap; > color:#666; > text-align:right; > } > #ygrp-actbar .left{ > float:left; > white-space:nowrap; > } > .bld{font-weight:bold;} > #ygrp-grft{ > font-family:Verdana; > font-size:77%; > padding:15px 0; > } > #ygrp-ft{ > font-family:verdana; > font-size:77%; > border-top:1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom:10px; > } > > #ygrp-vital{ > background-color:#e0ecee; > margin-bottom:20px; > padding:2px 0 8px 8px; > } > #ygrp-vital #vithd{ > font-size:77%; > font-family:Verdana; > font-weight:bold; > color:#333; > text-transform:uppercase; > } > #ygrp-vital ul{ > padding:0; > margin:2px 0; > } > #ygrp-vital ul li{ > list-style-type:none; > clear:both; > border:1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > font-weight:bold; > color:#ff7900; > float:right; > width:2em; > text-align:right; > padding-right:.5em; > } > #ygrp-vital ul li .cat{ > font-weight:bold; > } > #ygrp-vital a { > text-decoration:none; > } > > #ygrp-vital a:hover{ > text-decoration:underline; > } > > #ygrp-sponsor #hd{ > color:#999; > font-size:77%; > } > #ygrp-sponsor #ov{ > padding:6px 13px; > background-color:#e0ecee; > margin-bottom:20px; > } > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px; > margin:0; > } > #ygrp-sponsor #ov li{ > list-style-type:square; > padding:6px 0; > font-size:77%; > } > #ygrp-sponsor #ov li a{ > text-decoration:none; > font-size:130%; > } > #ygrp-sponsor #nc { > background-color:#eee; > margin-bottom:20px; > padding:0 8px; > } > #ygrp-sponsor .ad{ > padding:8px 0; > } > #ygrp-sponsor .ad #hd1{ > font-family:Arial; > font-weight:bold; > color:#628c2a; > font-size:100%; > line-height:122%; > } > #ygrp-sponsor .ad a{ > text-decoration:none; > } > #ygrp-sponsor .ad a:hover{ > text-decoration:underline; > } > #ygrp-sponsor .ad p{ > margin:0; > } > o {font-size:0;} > .MsoNormal { > margin:0 0 0 0; > } > #ygrp-text tt{ > font-size:120%; > } > blockquote{margin:0 0 0 4px;} > .replbq {margin:4;} > --> > > > > > > > > > > _____________________________________________________________________ _______________ > No need to miss a message. Get email on-the-go > with Yahoo! Mail for Mobile. Get started. > http://mobile.yahoo.com/mail > > [Non-text portions of this message have been removed] >
