topic Reading from a view, get date format error in QlikView

Reading from a view, get date format error

Tue, 02 Aug 2016 08:06:44 GMT

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 — Tue, 02 Aug 2016 08:23:41 GMT

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 — Tue, 02 Aug 2016 08:25:48 GMT

Tue, 02 Aug 2016 09:25:12 GMT

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.