Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk

From: Norman Dunbar <>
Date: Tue, 15 Nov 2011 15:57:14 +0000
Message-ID: <>


On 15/11/11 15:51, Denis wrote:
> ... However I really cannot cotrol vendor's code.
It's a bug! Report back to the vendor that they *must* use explicit date conversions.

Many years ago I worked as a developer in a software house. We always used an NLS_DATE_FORMAT of dd/mm/yyyy. Everything worked fine for years, until we got our first customer in the USA.

They found some dates were not coming out correctly = 07/04/2010 was, in the US default format, July 4th and not April 7th. That definitely screwed our date based calculations (of interest!)

They logged a bug, we fixed it. No more assumptions that the whole world uses the same default date format as we did.


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
Received on Tue Nov 15 2011 - 09:57:14 CST

Original text of this message