OraFAQ Forum: Client Tools » PL SQL Developer Date field

Home » Other » Client Tools » PL SQL Developer Date field (1.2.1)

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

PL SQL Developer Date field [message #352196]

Mon, 06 October 2008 10:15

reaz28
Messages: 4
Registered: October 2008

Junior Member

Guys,

I have but really can't figure this out please help:

On my sql-developer when ever there is DateTime field, it is showing the data in short DATE format, that is DD-MMM-YY (10-OCT-2007).

I run the same query on toad and the DATE is showing in correct format like 10-OCT-2007 05:09:22.

Can you tell what I have to do for PL/SQL Developer to show the date in correct format.

Please help.

thanks.

[Updated on: Mon, 06 October 2008 10:29]

Report message to a moderator

Re: PL SQL Developer Date field [message #352336 is a reply to message #352196]

Tue, 07 October 2008 03:18

scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England

Senior Member

Off the Tools menu select preferences.

Under User Interface theres a date/time option. You can set your date/time display options there.

Oracle format for the date and windows format for the time should be fine.

[Updated on: Tue, 07 October 2008 04:15]

Report message to a moderator

Re: PL SQL Developer Date field [message #352392 is a reply to message #352336]

Tue, 07 October 2008 07:54

reaz28
Messages: 4
Registered: October 2008

Junior Member

Thanks for your reply, but I couldn't find User Preference under Tools-- > Preferences option.

There is a DateTime on Database-->NLS Parameter. For Date the format is setup as DD-MON-RR and if I try to set it as DD-MON-RR HH.MI.SSXFF AM (this is the current format for Timestamp), pl/sql developer complains that the Date format is not recognised.

Report message to a moderator

Re: PL SQL Developer Date field [message #352394 is a reply to message #352392]

Tue, 07 October 2008 07:58

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

".SSXFF" is not a valid format for date only for timestamp.

Regards
Michel

Report message to a moderator

Re: PL SQL Developer Date field [message #352396 is a reply to message #352196]

Tue, 07 October 2008 08:00

reaz28
Messages: 4
Registered: October 2008

Junior Member

Mitch,

Thank you, yes when I used DD-MON-RR HH.MI, it worked.

Thanks all for your help. It's been bothering me for a longest period of time.

Reaz.

Report message to a moderator

Re: PL SQL Developer Date field [message #352397 is a reply to message #352396]

Tue, 07 October 2008 08:02

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"SS" is too much in my post, you can keep it. Only subsecond parameter (XFF) is not available in date.

Regards
Michel

Report message to a moderator

Previous Topic:	Can't see objects after connecting through developer
Next Topic:	Toad question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 11:06:22 CST 2024