Relative Content

Tag Archive for sqldb2parenthesescoalesce

Coalesce SQL to return the result with parenthesis (bracket) for the 2nd argument

I am trying to create a new column which can show the “Date Created” from the history table left joined with current table from the date column “TIMESTAMP” I use Oracle Interactive Reporting (IR) SQL querying tool to pull the data from the database DB2 .History table column is DB2.TABLEH.TIMESTAMP B and the Current table is DB2.TIMESTAMP A