Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I just want to ignore these '0000-00-00' how to achieve this?
if its for only one value then it would be
if(date<>'0000-00-00',date)
if its for only one value then it would be
if(date<>'0000-00-00',date)
If you need to this in the script you can do like this:
Table:
LOAD blahblah,
DATE
FROM Source
Where DATE <> '0000-00-00');
Thanks Avinash 🙂
Your always welcome