OraFAQ Forum: Client Tools » Toad displays RRRR

Home » Other » Client Tools » Toad displays RRRR (Oracle 10g XE)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Toad displays RRRR [message #280471]

Tue, 13 November 2007 15:27

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?

Report message to a moderator

Re: Toad displays RRRR [message #280544 is a reply to message #280471]

Wed, 14 November 2007 01:12

Littlefoot
Messages: 21807
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?

Report message to a moderator

Re: Toad displays RRRR [message #280546 is a reply to message #280544]

Wed, 14 November 2007 01:16

Frank
Messages: 7901
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.

Report message to a moderator

Re: Toad displays RRRR [message #280651 is a reply to message #280544]

Wed, 14 November 2007 05:40

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!

Report message to a moderator

Re: Toad displays RRRR [message #280655 is a reply to message #280651]

Wed, 14 November 2007 06:12

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.

Report message to a moderator

Re: Toad displays RRRR [message #280788 is a reply to message #280655]

Wed, 14 November 2007 14:10

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

Report message to a moderator

Re: Toad displays RRRR [message #280995 is a reply to message #280788]

Thu, 15 November 2007 06:23

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

Report message to a moderator

Re: Toad displays RRRR [message #281001 is a reply to message #280995]

Thu, 15 November 2007 06:38

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.

Report message to a moderator

Re: Toad displays RRRR [message #281004 is a reply to message #281001]

Thu, 15 November 2007 06:44

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.

Report message to a moderator

Re: Toad displays RRRR [message #281011 is a reply to message #281004]

Thu, 15 November 2007 06:59

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yet another inhabitant of The Matrix.

/forum/fa/3395/0/

Attachment: matrix3a.gif
(Size: 46.80KB, Downloaded 3700 times)

Report message to a moderator

Re: Toad displays RRRR [message #281023 is a reply to message #281011]

Thu, 15 November 2007 07:24

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.

Report message to a moderator

Re: Toad displays RRRR [message #281029 is a reply to message #281023]

Thu, 15 November 2007 07:32

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

Report message to a moderator

Re: Toad displays RRRR [message #281041 is a reply to message #281029]

Thu, 15 November 2007 07:56

Littlefoot
Messages: 21807
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.

Report message to a moderator

Previous Topic:	TOAD
Next Topic:	Relative path to spool file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 04:59:47 CDT 2024