Toad World® Forums

To partially Match cell against another partial cell

I have a problem with two tables which I need to compare dates for the same reference. The problem is that a) the dates are different formats and b) superfluous data is also contained within both date cells.

Global

No. Date
1 1992-08-25 00:00:00.000
2 2015-05-19 00:00:00.000
3 2000-01-12 00:00:00.000

Local

No. Date
1 25.08.1992 00:00:00.000000000 GMT
1 28.08.1992 00:00:00.000000000 GMT
2 19.05.2015 00:00:00.000000000 GMT
3 12.01.2000 00:00:00.000000000 GMT
3 17.01.2000 00:00:00.000000000 GMT

Note that the date formats between the two tables differ and contain lots of time and zero data that is not needed. So ideally I would like to see the format as DD-MM-YYYY.

I would like to return only the Global and Local entries where the Local date differs from Global date. So from the data above, I would want to see:

No. Date No. Date
1 25-08-1992 1 28-08-1992
3 12-01-2000 3 17-01-2000

I would put my attempts so far, but to be honest I have no idea on how to tackle the partial cell matching and re-formatting.

Any ideas?

Thanks

Nagesh Kumar