Home » SQL & PL/SQL » Client Tools » Toad displays RRRR (Oracle 10g XE)
Toad displays RRRR [message #280471] Tue, 13 November 2007 15:27 Go to next message
Slow_moe
Messages: 7
Registered: November 2007
Location: Oslo
Junior Member
Hi everybody, I've searched my Toad settings and just cannot
find this out.. If I start up fresh and simply run

SELECT TRUNC (SYSDATE)
  FROM DUAL


by pressing F9 i get the expected 13.11.2007,
but if I run it with F5 I get

TRUNC(SYSD
----------
13.11.RRRR

1 row selected.

Anybody?
Re: Toad displays RRRR [message #280544 is a reply to message #280471] Wed, 14 November 2007 01:12 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
My TOAD 8.6.1 doesn't behave like that; the result is:

F9: 14.11.2007
F5: 14.11.07

Which version do you use?
Re: Toad displays RRRR [message #280546 is a reply to message #280544] Wed, 14 November 2007 01:16 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
By the look of your two outcomes, I'd say that there are two separate format-masks for those. You probably have an invalid format mask defined for the RRRR.
Re: Toad displays RRRR [message #280651 is a reply to message #280544] Wed, 14 November 2007 05:40 Go to previous messageGo to next message
Slow_moe
Messages: 7
Registered: November 2007
Location: Oslo
Junior Member

Hi, my Toad is version 9.0.1.8 and the OS is Vista Home ed.

Are you suggesting it's a setting in the database and not
in Toad, Frank? Where do I look up format masks to check if
they are different. I don't get why it's OK in the grid and
not in the script output, though.
Thanks both for your help!
Re: Toad displays RRRR [message #280655 is a reply to message #280651] Wed, 14 November 2007 06:12 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you look in the TOAD options, there is a specific date format mask for the data grid. Everywhere else should default to the normal NLS date format.
Re: Toad displays RRRR [message #280788 is a reply to message #280655] Wed, 14 November 2007 14:10 Go to previous messageGo to next message
Slow_moe
Messages: 7
Registered: November 2007
Location: Oslo
Junior Member
Hi, yes I've found the settings for the grid. That works.
However, I haven't solved the RRRR-issue.
Running the same code after submitting
ALTER SESSION SET nls_date_format = 'dd.mm.yyyy';

doesn't change a thing.. Confused
I'll probably just get rid of XE anyway and install
the whole shebang; 10.2 personal or something..

Thanks for your help guys,
A
Re: Toad displays RRRR [message #280995 is a reply to message #280788] Thu, 15 November 2007 06:23 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'd be suprised if changing the Db helped - this is a TOAD thing.

If I run that statement with F5 I get the stunningly useful output
O
V
-
0
7
                                                                                

1 row selected.

We're on 10.2.0.1.0
Re: Toad displays RRRR [message #281001 is a reply to message #280995] Thu, 15 November 2007 06:38 Go to previous messageGo to next message
Slow_moe
Messages: 7
Registered: November 2007
Location: Oslo
Junior Member
Cool, so if we combine forces
and use my DD.MM. and your YY we're
good to go Smile

I realize it's a Toad issue, but
I'm installing 10.2 anyway. You never know,
problems sometimes disappear just like that..
Maybe I'll just contact Quest for assistance on this one.
Re: Toad displays RRRR [message #281004 is a reply to message #281001] Thu, 15 November 2007 06:44 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ahhhh mea culpa.

I didn't notice the scroll bar on the window.
I'm actually getting the result:
S
-
1
5
-
N
O
V
-
0
7
                                                                                

1 row selected.
Re: Toad displays RRRR [message #281011 is a reply to message #281004] Thu, 15 November 2007 06:59 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yet another inhabitant of The Matrix.

./fa/3395/0/
  • Attachment: matrix3a.gif
    (Size: 46.80KB, Downloaded 2219 times)
Re: Toad displays RRRR [message #281023 is a reply to message #281011] Thu, 15 November 2007 07:24 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
For some reason, the script runner seems to think that sysdate is a 1 chr wide column. If you give it something where it can work out the colum,n width then it's fine, but a date just throws it:
SELECT  'aaaaa',to_char(sysdate,'dd-mm-yyyy'), sysdate, to_Date('01-01-1900','dd-mm-yyyy')
  FROM casts where rownum <=1;
  
'AAAA TO_CHAR(SY S T
----- ---------- - -
aaaaa 15-11-2007 1 0
                 5 1
                 - -
                 N J
                 O A
                 V N
                 - -
                 0 0
                 7 0
                                                                                

1 row selected.
Re: Toad displays RRRR [message #281029 is a reply to message #281023] Thu, 15 November 2007 07:32 Go to previous messageGo to next message
Slow_moe
Messages: 7
Registered: November 2007
Location: Oslo
Junior Member
That's just weird!
Unfortunately I'm at work so I can't access my home-db
where the R-problem resides. However, I've connected to
three different db's here at work, and I get

TRUNC(SYS
---------
15-NOV-07

from all, which I would like to change to
15.11.2007 for one of them, but don't know how.

Cheers,
A
Re: Toad displays RRRR [message #281041 is a reply to message #281029] Thu, 15 November 2007 07:56 Go to previous message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In TOAD (8.6.1 - it may differ in your version), go to View menu, select "Options ...". "Data Grids" node, "Data". On the right side of the screen you'll see "Display" section - change "Date format" as desired.
Previous Topic: TOAD
Next Topic: Relative path to spool file
Goto Forum:
  


Current Time: Mon Dec 05 12:58:16 CST 2016

Total time taken to generate the page: 0.07046 seconds