SQL - Date-Q
From: Per Andersson <per.andersson_at_enator.se>
Date: 1996/08/13
Message-ID: <32108E68.759B_at_enator.se>#1/1
Date: 1996/08/13
Message-ID: <32108E68.759B_at_enator.se>#1/1
Hello!
I have a "Date" stored as CHAR.
Why cant I do a TO_DATE('1996333','YYYYWWD') on this string?
Example: 1996333 (fmt = YYYYWWD, year week day_of_week)...
Oracle returns ORA-01820: format code cannot appear in date input format
Per Andersson, Enator
(per.andersson_at_enator.se)
Received on Tue Aug 13 1996 - 00:00:00 CEST