Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 24th, 2004, 07:27 AM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default Setting NLS_TIMESTAMP_FORMAT global parameter

Hi everyone,

I am trying to set the NLS_TIMESTAMP_FORMAT parameter globally on my Oracle database. I shutdown the database and edit the initialization file that I use during startup. I added the following:

nls_timestamp_format = 'MM-DD-YYYY HH:MI:SS AM'

However, the change is never reflected. Also when I shut down the database, the initialization file is edited to:

nls_timestamp_format = AM

I am not sure what I am doing wrong. I would really appreciate any suggestion or help.

Thanks,
Pankaj






Similar Threads
Thread Thread Starter Forum Replies Last Post
How to declare the global variable in global.asax? calyn_gately ASP.NET 3.5 Basics 0 August 6th, 2008 08:06 PM
Global parameter calculation inside template Volder XSLT 8 June 20th, 2008 08:10 AM
Setting Global Parameters in the SimpleAxisServer nigel.sim J2EE 0 October 8th, 2005 06:46 PM
Setting a DTS Global Variable ioates SQL Server 2000 0 October 23rd, 2003 04:28 AM
Local setting parameter Lukas C# 0 October 13th, 2003 11:47 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.