Informix weekday calendar function not working

136 Views Asked by At

I am new to Informix. I tried creating timeseries calendar pattern which should store data only for weekdays (Monday-Friday).

I inserted the data below for that into CalendarPatterns table:

INSERT INTO CalendarPatterns (cp_name, cp_pattern)
    VALUES ('5day_ptrn', '{1 off, 5 on, 1 off}, day');

While trying to inserting record into a table which is using this calendar pattern, it's storing data for Saturday and Sunday but not storing data for Thursday and Friday.

Please advise where I am going wrong.

0

There are 0 best solutions below