From oracle-l-bounce@freelists.org Sat Jun 26 16:37:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5QLbgo26790 for ; Sat, 26 Jun 2004 16:37:52 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5QLbM626755 for ; Sat, 26 Jun 2004 16:37:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50DF672C160; Sat, 26 Jun 2004 16:20:23 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11310-52; Sat, 26 Jun 2004 16:20:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D48D72C09E; Sat, 26 Jun 2004 16:20:22 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 26 Jun 2004 16:18:54 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E52DA72C102 for ; Sat, 26 Jun 2004 16:18:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03788-96 for ; Sat, 26 Jun 2004 16:18:53 -0500 (EST) Received: from ross.alise.lv (ross.alise.lv [194.19.227.242]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E2D872C02B for ; Sat, 26 Jun 2004 16:18:53 -0500 (EST) In-Reply-To: To: oracle-l@freelists.org Subject: RE: NLS DATE MIME-Version: 1.0 X-Mailer: Lotus Notes Release 6.5.1 January 21, 2004 Message-ID: From: J.Velikanovs@alise.lv Date: Sun, 27 Jun 2004 00:33:39 +0300 X-MIMETrack: Serialize by Router on ROSS/IT ALISE/LV(Release 5.0.11 |July 24, 2002) at 2004.06.27 00:33:42, Serialize complete at 2004.06.27 00:33:42 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3758 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: J.Velikanovs@alise.lv Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org CREATE OR REPLACE TRIGGER logon_vjv AFTER LOGON ON DATABASE begin execute immediate 'alter session set NLS_DATE_FORMAT=''YYYY/MM/DD'''; end; / or any format you want. Jurijs "Jacques Kilchoer" Sent by: oracle-l-bounce@freelists.org 25.06.2004 00:04 Please respond to oracle-l To: cc: Subject: RE: NLS DATE When you say "I want whole table data should be like..." You do realize that the DATA inside the Oracle table is the same regardless of your NLS_DATE_FORMAT? If you want this display only in SQL*Plus, you can change the glogin.sql file to have an ALTER SESSION SET NLS_DATE_FORMAT...=20 If you want this display only in this particular SQL statement, you can use TO_CHAR to format the date whichever way you want. If you want this display for every client application from a particular machine, you would have to set NLS_DATE_FORMAT on the client in an environment variable. You can set these values at the instance level, but it will be overridden by the settings on any client machine. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Seema Singh Sent: jeudi, 24. juin 2004 12:33 To: oracle-l@freelists.org Subject: NLS DATE=20 Hi, How to fix NLS_DATE_FORMAT problem without altering the session? Like NO TDATE ---------- --------- 10 24-JUN-04 20 24-JUN-04 I want like NO TDATE ---------- ---------- 10 2004-06-24 20 2004-06-24 Is any parameter which need to setup at init.ora file? I tried yyyy-mm-dd=20 but didn't helped? I want whole table data should be like "yyyy-mm-dd'. pLEASE suggest if any? thx _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar - get it now!=20 http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------