variable in where sql statement (incremental load)
I have a field called updatedwhich is a timestamp field which in Postgres has the following format : 'YYYY-MM-DD hh:mm:ss.fff'
I loaded the table in which it belongs in data load script and formatted it as such timestamp(date(updated),'YYYY-MM-DD h:mm:ss.fff ') as updated
I also have the statement Let Last_Update_Date=timestamp(date(Peek('MaxDate',0,'Last_Update_Date')),'YYYY-MM-DD h:mm:ss.fff '); because i'm trying to do an incrememental load.However, in the where condition in the sql part of the load which is where updated> $(Last_Update_Date);
, i get errors all the time and i'm pretty sure it's the format.