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 October 9th, 2004, 06:14 AM
Registered User
 
Join Date: Oct 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default date storage

how to alter the date format of the table

Eg: how to store the date in the format JANUARY 10,1975
 
Old October 10th, 2004, 03:16 PM
Registered User
 
Join Date: Sep 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

in sqlplus
ALTER SESSION SET NLS_DATE_FORMAT = ''Month dd,YYYY''
in form
 forms_ddl('ALTER SESSION SET NLS_DATE_FORMAT = ''DD/MM/YYYY''');


Waheed rashwan
 
Old October 11th, 2004, 12:04 AM
Registered User
 
Join Date: Oct 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thank you Waheed Rashwan for the post but ALTER SESSION SET NLS_DATE_FORMAT does not permanently affect the permanent date storage for a particular table to be viewed in the format whenever it is opened..it merely affects the temporary way to view the format in that format..does anybody know how to alter/insert the date in a particular format so that it is permanently stored in the table in that format,,be it other than the default date format set for the system.


Quote:
quote:Originally posted by wahras
 in sqlplus
ALTER SESSION SET NLS_DATE_FORMAT = ''Month dd,YYYY''
in form
forms_ddl('ALTER SESSION SET NLS_DATE_FORMAT = ''DD/MM/YYYY''');


Waheed rashwan
 
Old October 12th, 2004, 12:52 AM
Authorized User
 
Join Date: Apr 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Oracle will always store DATE data in a packed binary format. This is handy for computers to use, but incomprehensible to applications. It is impossible to change the way Oracle stores a date.

It is the job of the client application, like SQL*Plus, to turn this binary data into a format that is comprehensible to the user. Oracle's tools will use NLS_DATE_FORMAT to determine how to display dates by default, though you can always use TO_CHAR to do an explicit format. NLS_DATE_FORMAT can be set at the session level, at the client level by setting an environment variable, or at the database level, by changing the initialization parameter. Individual sessions, however, can always override client and database level settings. Additionally, non-Oracle tools will generally not use NLS_DATE_FORMAT and will end up using their own date format.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
 
Old October 20th, 2004, 03:59 AM
Registered User
 
Join Date: Oct 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to mg2010 Send a message via Yahoo to mg2010
Default

when i try to user imp80 this messeage be declare imp-00000






Similar Threads
Thread Thread Starter Forum Replies Last Post
Storage Engine ashuphp Beginning PHP 1 April 19th, 2007 12:13 AM
Could not open macro storage tigerkit Beginning VB 6 7 September 20th, 2006 02:56 PM
intermediate storage sarah lee ASP.NET 1.0 and 1.1 Basics 3 September 11th, 2006 01:31 PM
opinion on data storage phlint69 Access VBA 2 September 27th, 2005 08:16 AM
Document Storage hugh@kmcnetwork.com SQL Server 2000 1 December 23rd, 2003 10:36 AM





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