Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was hoping to load with date between . i.e
LOAD
A
B
C
FROM dbs
where Date(APPLIED_DATE,'yyyy/MM/dd') >= '2010/01/01' and Date(APPLIED_DATE,'yyyy/MM/dd') <= '2012/31/01' ;
Please help with the syntax. Thanks
HI
Try like this
Load * from tableName where Date(APPLIED_DATE,'YYYY/MM/DD') >= Date#('2010/01/01','YYYY/MM/DD') and Date(APPLIED_DATE,'YYYY/MM/DD') <= Date#('2012/31/01', 'YYYY/MM/DD');
Can you say applied date is in correct format for date? try with date#() also once. May be format is incorrect.
HI
Try like this
Load * from tableName where Date(APPLIED_DATE,'YYYY/MM/DD') >= Date#('2010/01/01','YYYY/MM/DD') and Date(APPLIED_DATE,'YYYY/MM/DD') <= Date#('2012/31/01', 'YYYY/MM/DD');
Can you say applied date is in correct format for date? try with date#() also once. May be format is incorrect.
Thanks a lot Mayil it worked just fine.