Hi all,
I'm using windows 10 version 1803, Entity Developer 6.3.555, Postgres 10.4
I have a table with a column of type timetz and a function that selects records based on an argument of type time.
On attempting to update my model in Entity developer I get this this error:
1 The DbType value of the parameter '_2' in the method 'FnPricesToDate' is not valid. The data type 'TIME WITH TIME ZONE' is not supported. C:\Users\***\DataAccess\***.lqml
Other time types show similar behavior. However, if I change the column and argument to a date type then the model will update correctly. But I want to be able to make that comparison based on time, not date.
How can I proceed?
Thanks
support of functions with time data type arguments
Re: support of functions with time data type arguments
Thank you for your report. We will notify you when the issue with timetz is fixed.
Re: support of functions with time data type arguments
The bug is fixed in the newest (7.11.1216) build of dotConnect for PostgreSQL.
Re: support of functions with time data type arguments
Thanks Shalex, it's working perfectly now