When testing ODBC on proxy, it returns different result than when actually executing due to test being performed by task manager instead of ODBC poller and task manager has connection to database which causes it to have different locale.

A solution could be to outsource to poll the metric to a process, which is actually responsible for the item type.