Date Correction in DB

Hi there,

I have two table that I would like to join in DB as they’re huge, one of the join parameters is a date, and they do not line up, one set is 2020:02:01 , 2020:03:01 and the other is 2020:02:29 , 2020:03:01 etc, one always has first of the month, the other is last date. Is there a way to manipulate the date in DB? And for that matter is there any way to do any formulas in-DB? LIke say adding two rows?

thanks a lot

@rossmc
Do you plan to format date and join yyyy:mm = yyyy:mm ?

1 Like

Hi there @rossmc,

so you can try following. Use DB Joiner node regardless of this mismatch. Then use DB Query Extractor to get the joining query which you should manipulate to get your date columns in line. Then feed new query as a flow variable to DB Query in order to do execution on DB.

Regarding manipulation in database data you can do whatever can be done using SQL :wink:

Br,
Ivan

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.