{"action":"closed","issue":{"url":"https://api.github.com/repos/RobWunderlich/Qlikview-Components/issues/26","labels_url":"https://api.github.com/repos/RobWunderlich/Qlikview-Components/issues/26/labels{/name}","comments_url":"https://api.github.com/repos/RobWunderlich/Qlikview-Components/issues/26/comments","events_url":"https://api.github.com/repos/RobWunderlich/Qlikview-Components/issues/26/events","html_url":"https://github.com/RobWunderlich/Qlikview-Components/issues/26","id":61063638,"number":26,"title":"Timestamp conditional error for cultural separator settings","user":{"login":"pljluca","id":10811092,"avatar_url":"https://avatars.githubusercontent.com/u/10811092?v=3","gravatar_id":"","url":"https://api.github.com/users/pljluca","html_url":"https://github.com/pljluca","followers_url":"https://api.github.com/users/pljluca/followers","following_url":"https://api.github.com/users/pljluca/following{/other_user}","gists_url":"https://api.github.com/users/pljluca/gists{/gist_id}","starred_url":"https://api.github.com/users/pljluca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pljluca/subscriptions","organizations_url":"https://api.github.com/users/pljluca/orgs","repos_url":"https://api.github.com/users/pljluca/repos","events_url":"https://api.github.com/users/pljluca/events{/privacy}","received_events_url":"https://api.github.com/users/pljluca/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"RobWunderlich","id":6088580,"avatar_url":"https://avatars.githubusercontent.com/u/6088580?v=3","gravatar_id":"","url":"https://api.github.com/users/RobWunderlich","html_url":"https://github.com/RobWunderlich","followers_url":"https://api.github.com/users/RobWunderlich/followers","following_url":"https://api.github.com/users/RobWunderlich/following{/other_user}","gists_url":"https://api.github.com/users/RobWunderlich/gists{/gist_id}","starred_url":"https://api.github.com/users/RobWunderlich/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RobWunderlich/subscriptions","organizations_url":"https://api.github.com/users/RobWunderlich/orgs","repos_url":"https://api.github.com/users/RobWunderlich/repos","events_url":"https://api.github.com/users/RobWunderlich/events{/privacy}","received_events_url":"https://api.github.com/users/RobWunderlich/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-03-13T13:27:53Z","updated_at":"2015-03-13T21:14:18Z","closed_at":"2015-03-13T21:14:18Z","body":"Hello,\r\n\r\nI tried to load data from a DB table where I have a field Reference$LastUpdateDate (it is an TIMESTAMP), my DB is Oracle.\r\nAt the first loading all it's ok, all rows are loaded. After, in the second or more loading I seen that the query executed is \r\n\r\n```\r\nSELECT * FROM MyTable\r\nWHERE REFERENCES$LASTUPDATEDATE >= TIMESTAMP '2015-01-29 00:00:00'; \r\n```\r\nand not \r\n```\r\nWHERE REFERENCES$LASTUPDATEDATE >= TIMESTAMP '2015-01-29 18:10:54'; \r\n```\r\n\r\nI tried to change my settings FROM\r\n```\r\nSET ThousandSep='.';\r\nSET DecimalSep=',';\r\n```\r\nTO\r\n```\r\nSET ThousandSep=',';\r\nSET DecimalSep='.';\r\n```\r\nand now the executed query is correctly\r\n```\r\nSELECT * FROM MyTable\r\nWHERE REFERENCES$LASTUPDATEDATE >= TIMESTAMP '2015-01-29 18:10:54'; \r\n```\r\n\r\nOthers settings\r\n```\r\nSET MoneyThousandSep='.';\r\nSET MoneyDecimalSep=',';\r\nSET MoneyFormat='€ #.##0,00;-€ #.##0,00';\r\nSET TimeFormat='hh:mm:ss';\r\nSET DateFormat='DD/MM/YYYY';\r\nSET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';\r\nSET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';\r\nSET DayNames='lun;mar;mer;gio;ven;sab;dom';\r\n```\r\n\r\nI think that the solution is change row 128 and 131 in Qvc_Incremental_Reload.qvs\r\n```\r\nSET Qvc.Loader.v.IncrementalFloor = $(_vDate.Max);\t// Save copy for user defined custom where expression\r\n\r\n// Create a where predicate\r\nLET Qvc.Loader.v.IncrementalExpression = '$(_vSqlModField) ' & $(_tempLoaderPredicate($(_vDate.Max)));\t\r\n```\r\nwith\r\n```\r\nLET Qvc.Loader.v.IncrementalFloor = Replace('$(_vDate.Max)', '$(DecimalSep)', '.');\t// Save copy for user defined custom where expression\r\n\r\n// Create a where predicate\r\nLET Qvc.Loader.v.IncrementalExpression = '$(_vSqlModField) ' & $(_tempLoaderPredicate($(Qvc.Loader.v.IncrementalFloor)));\t\r\n```\r\n\r\nBest regards\r\nLuca Jonathan Panetta\r\n"}}