Oracle NLS_DATE_FORMAT 변경

1) 오라클 환경변수 조회하기
select * from v$nls_parameters;

2) 날짜형식 변경하기
alter session set nls_date_format = 'YYYY-MM-DD'; //datefromat변경
alter session set nls_timestamp_format = 'YYYY-MM-DD HH:MI:SS'; //timestamp_format변경

3) 정상적으로 변경되었는지 확인
select * from emp
where hiredate = '1981-02-22';

/*alter [session/system]
 1. session : 현재접속한 session(쿼리)에서만 변경
 2. system : database자체를 변경
  scope=[both/spfile]
  -both : 바로적용 또는 재시작(오류날 가능성이 높다)
  -spfile : DB를 재시작후에 변경
*/

**SQL Command Line으로 들어가서 system계정으로 접속해서 바꿔야 한다.(영구적 변경)
alter system
 set nls_date_format = 'YYYY-MM-DD'
  scope=spfile;
alter system
 set nls_timestamp_format = 'YYYY-MM-DD HH:MI:SS'
  scope=spfile;

4)sqlplus에 sys as sysdba 로 접속해서, shutdown immediate;startup; 실행

댓글

댓글 쓰기

이 블로그의 인기 게시물

Stop console process using Ctrl+C.

http://stackoverflow.com/questions/813086/can-i-send-a-ctrl-c-sigint-to-an-application-on-windows https://msdn.microsoft.com/en-us/library/ms686016(VS.85).aspx private void Button1_OnClick(object sender, RoutedEventArgs e) { var file = new FileInfo(@"C:\temp\video.mp4"); if (file.Exists) { file.Delete(); } ct = new CancellationTokenSource(); Task.Factory.StartNew(() => { var pInfo = new ProcessStartInfo("cmd.exe", string.Format("/c {0} \"{1}\"", new object[] {"adb.bat", file.Name})); pInfo.CreateNoWindow = true; pInfo.UseShellExecute = false; pInfo.RedirectStandardError = true; pInfo.RedirectStandardOutput = true; pInfo.RedirectStandardInput = true; var p = Process.Start(pInfo); ...
자세한 내용 보기

Alternative to IValueConvert, QuickConverter

https://quickconverter.codeplex.com/ Quick Setup Steps Add the assembly reference to your project. This can also easily be done using  the NuGet package . Add the namespaces to Quick Converter that it will need to know about (before any xaml that uses it is loaded). e.g. In your WPF application's App.xaml.cs file: public   partial   class   App  :  Application { public  App() :  base () { // Setup Quick Converter. // Add the System namespace so we can use primitive types (i.e. int, etc.). QuickConverter. EquationTokenizer .AddNamespace( typeof ( object )); // Add the System.Windows namespace so we can use Visibility.Collapsed, etc. QuickConverter. EquationTokenizer .AddNamespace( typeof (System.Windows. Visibility )); } } Add the Quick Converter namespace to your xaml files so you can ref...
자세한 내용 보기