Marco van der Linden
Member³
Fact: Date is 31-Dec-4712
With date/time in 'Windows format', the SQL grid displays '31/12/4712' and the calendar pop-up states the year to be 4712.
With date/time in 'Oracle format', the SQL grid displays '31-Dec-12' but the calendar pop-up states the year to be 2012.
It seems the calendar pop-up looks at the display value rather then the actual value.
No big thing, but worth mentioning anyway
With date/time in 'Windows format', the SQL grid displays '31/12/4712' and the calendar pop-up states the year to be 4712.
With date/time in 'Oracle format', the SQL grid displays '31-Dec-12' but the calendar pop-up states the year to be 2012.
It seems the calendar pop-up looks at the display value rather then the actual value.
No big thing, but worth mentioning anyway