Reading from a view, get date format error

[#1]

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.

[jonathandienst]

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

[jonathandienst]

smalldatetime (Transact-SQL)

[#4]

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.