Where clause with date issue in Loading

[berryandcherry6]

Hi,

I want to load data where expiration date is greater than today, when i load script it doesnt filter data above expiration date greater than today(). Below shows all data.

in my databse i have date in this format 2015-02-11 23:59:59

let varExpirationDate  = Timestamp(Today(),'MM-DD-YYYY hh:mm:ss');

LOAD `campaign_id`,

     `campaign_group_id`,

     `start_date`,

      expiration_date;

SQL SELECT `campaign_id`,

     `start_date`,

     `campaign_group_id`,

      expiration_date,

FROM rcdb.CAMPAIGN where expiration_date >= '$(varExpirationDate)';

what am i missing?

[nilesh_gangurde · Accepted solution]

Hi Supriya,

See the Date format.

databse  format 2015-02-11 23:59:59

let varExpirationDate  = Timestamp(Today(),'MM-DD-YYYY hh:mm:ss');

The variable Should be :

let varExpirationDate  = Timestamp(Today(),'YYYY-MM-DD hh:mm:ss');

Hope this helps.

[berryandcherry6]

Thanks Nilesh,

For pointing out error in my code, i dint even realized it.

Sorry guys for your time.