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

CostinMarzea — Sat, 16 Nov 2024 00:38:34 GMT

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

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

CostinMarzea — Mon, 22 Feb 2021 08:05:04 GMT

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