How to ignore unwanted things in DATE format.

[MuraliPrasath]

I just want to ignore these '0000-00-00' how to achieve this?

[avinashelite · Accepted solution]

if its for only one value then it would be

if(date<>'0000-00-00',date)

[sunny_talwar]

If you need to this in the script you can do like this:

Table:

LOAD blahblah,

          DATE

FROM Source

Where DATE <> '0000-00-00');

[MuraliPrasath]

Thanks Avinash 🙂

[avinashelite]

Your always welcome