tDBInput_1 (JDBC) SQL Builder Where with Global Variable date type

[CostinMarzea]

Hi,

It is a simple SCD Dim Population, with last date modified from source > max

I've created GlobalVar to get max(last date updated) in dwh layer, so data type is Datetime2 19 positions "yyyy-MM-dd HH:mm:ss"

i am using this syntax in tMap with no problems :

((Date) globalMap.get("max_date"))

The value is 2021-02-10 05:49:57 same pattern as SQL Server : GETDATE()

2021-02-10 05:51:12

This Query Works Fine in SQL Builder : 

SELECT 

 "ACCOUNTS"."ACCOUNT_ID", 

 "ACCOUNTS"."DATE_LAST_MODIFIED", 

 "ACCOUNTS"."PARENT_ID", 

FROM "ACCOUNTS"

where "ACCOUNTS"."DATE_LAST_MODIFIED">GETDATE()

I tried all sorts of quotes and double quotes plus sign etc... I saw on Web , I need please an answer from some one that achieved it

my problem is with this where

SELECT 

 "ACCOUNTS"."ACCOUNT_ID", 

 "ACCOUNTS"."DATE_LAST_MODIFIED", 

 "ACCOUNTS"."PARENT_ID", 

FROM "ACCOUNTS"

where "ACCOUNTS"."DATE_LAST_MODIFIED">((Date) globalMap.get("max_date"))

Thank you Very Much

[CostinMarzea]

Really?? no one knows? ... shocking !