Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following load script:
.......
SET TimestampFormat='DD-MM-YYYY';
.......
LOAD
My problem is:
If i load the table without the WHERE condition, my EVENT_DATE field is in corect format (DD-MM-YYYY).
After I put the WHERE condition, EVENT_DATE transforms to numeric format (ex: 38270)...and my WHERE condition is not working...but I don't receive any error in executing the script.
I wold like to give the condition for loading my table where EVENT_DATE>'01-01-2011' and the EVENT_DATE field format to remain the same...
Thanks a lot!
CLAIM_ID,
CLAIM_REGID,
CLAIM_STARTED,
EVENT_DATE,
INSR_TYPE FROM
EVENT_DATE > '01-01-2011';
WHERE
The possible solution still applies:
CLAIM_ID,
CLAIM_REGID,
CLAIM_STARTED,
EVENT_DATE,
INSR_TYPE
FROM
WHERE date(EVENT_DATE, 'DD-MM-YYYY') > '01-01-2011';
Hi Sandries,
Try have you tried adding a date format i.e. :
date(EVENT_DATE, 'DD-MM-YYYY') > '01-01-2011' ....
Sorry for the inconvenience of my post...It should look like:
Hi all,
I have the following load script:
.......
SET TimestampFormat='DD-MM-YYYY';
.......
LOAD
CLAIM_ID,
CLAIM_REGID,
CLAIM_STARTED,
EVENT_DATE,
INSR_TYPE
FROM
WHERE EVENT_DATE > '01-01-2011';
My problem is:
If i load the table without the WHERE condition, my EVENT_DATE field is in corect format (DD-MM-YYYY).
After I put the WHERE condition, EVENT_DATE transforms to numeric format (ex: 38270)...and my WHERE condition is not working...but I don't receive any error in executing the script.
I would like to give the condition for loading my table where EVENT_DATE>'01-01-2011' and the EVENT_DATE field format to remain the same...
Thanks a lot!
The possible solution still applies:
CLAIM_ID,
CLAIM_REGID,
CLAIM_STARTED,
EVENT_DATE,
INSR_TYPE
FROM
WHERE date(EVENT_DATE, 'DD-MM-YYYY') > '01-01-2011';
Very nice solution.
Thank's a lot!