You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
the type ts_array is a table of timestamp. But the procedures time_start and time_stop uses systimestamp; that has a time zone specified. I am at GMT+2, and regularly have something like this in the logger table:
START: test
STOP : test- 01:59:59.969
So the ts_array shold be defined by timestamp with time zone or you should use localtimestamp instead of systimestamp
The text was updated successfully, but these errors were encountered:
the type ts_array is a table of timestamp. But the procedures time_start and time_stop uses systimestamp; that has a time zone specified. I am at GMT+2, and regularly have something like this in the logger table:
START: test
STOP : test- 01:59:59.969
So the ts_array shold be defined by timestamp with time zone or you should use localtimestamp instead of systimestamp
The text was updated successfully, but these errors were encountered: