How to Join 2 different datetime values into Final DateTime variable

[Learning Rocks]

Hello Everyone,

I am getting I have to 2 different datetime fields from database like below.

date time
2020-05-28 00:00:00 2020-05-28 12:00:00

Here i want to check time part of time field and join with date field if exists. i mean i want the result for date field like below if time exists. else as it is date should display.

date
2020-05-28 00:00:00

How to do it. please help me

Thanks

Continue reading...