The general rule for any string to date (and vice versa) conversion shoul be:
NEVER RELY ON DEFAULT DATE FORMAT (whther on server or on client side)!!!!!!
Always (without exception!) use explicite TO_DATE/TO_CHAR conversion with proper format mask. Oracle has to perform conversion in any case, so it is better that you tell it in advance what format mask it should use.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?