Home » SQL & PL/SQL » Client Tools » PL SQL Developer Date field (1.2.1)
PL SQL Developer Date field [message #352196] Mon, 06 October 2008 10:15 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.

Re: PL SQL Developer Date field [message #352394 is a reply to message #352392] Tue, 07 October 2008 07:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
".SSXFF" is not a valid format for date only for timestamp.

Regards
Michel

Re: PL SQL Developer Date field [message #352396 is a reply to message #352196] Tue, 07 October 2008 08:00 Go to previous messageGo to next message
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.
Re: PL SQL Developer Date field [message #352397 is a reply to message #352396] Tue, 07 October 2008 08:02 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Can't see objects after connecting through developer
Next Topic: Toad question
Goto Forum:
  


Current Time: Fri Dec 09 09:29:35 CST 2016

Total time taken to generate the page: 0.07780 seconds