Help us understand the problem. What is going on with this article?

Oracle DeveloperでDate型の表示書式を変える方法

環境

Oracle 12c 1.0

手順

  1. Developerの上部メニューから[ツール]を選択
  2. [プリファレンス]を選択してダイアログを開く
  3. 画面左のメニューツリーから[データベース]→[NLS]を選択
  4. 画面に「データベース:NLS」が表示されたら、[日付書式]項目を任意の書式に書き換える。

キャプチャ.PNG

書式の指定例

下記クエリ実行時

select sysdate from dual;

デフォルト:RR-MM-DD
 ⇒ 19-07-18
ハイフン区切り:YYYY-MM-DD HH24:MI:SS
 ⇒ 2019-07-18 13:20:27
スラッシュ区切り:YYYY/MM/DD HH24:MI:SS
 ⇒ 2019/07/18 13:20:27
区切りなし:YYYYMMDDHH24MISS
 ⇒ 20190718132027

※しかしたまに設定変更していてもデフォルト表示される場合がある…
 そんな時は再起動したりしてます(必ず戻るわけではない)

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした