Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to read from a view but get a error regarding the date format. It reads "day of month must be between 1 and last day of month"
The problem is within the sql query that creates the view, it complains on the date '9999-12-31 00:00:00'
where
a.IP_HUB_SQN = b.IP_HUB_SQN
and a.IP_HUB_SQN = c.IP_HUB_SQN
and a.ROW_END_DTTM = '9999-12-31 00:00:00'
and a.CRNT_F = 'Y';
What seems to be the problem and how can I get pass it?
Thanks for any help.
Is this in a SQL SELECT? Then this is really a SQL question. You may also want to seek help on a suitable SQL forum.
What SQL DBMS is this for?
What is the default date format on the server?
Is the field a small datetime field? This format does not extend as far as the normal datetime
Thank you. You are right, it is a SQL question. It is a date field in Oracle but I solved it now by using
ROW_END_DTTM=TO_DATE('9999-12-31 00:00:00', 'yyyy/mm/dd hh24:mi:ss') in the query.