I have two columns createdt and changedt both character 14 looks like (20101108140439) I want to do daily load based upon these two dates with date() function
So sumthing like this if createdt or changedt changed in last 2 days capture those last 2 days and insert data
Select * from aa
Where createdt or changedt <= date() -2 days
Other thing is we have global macro &loaddt if I want to use that
Instead of date() how can I do tht.