Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to pull some data from an Oracle database using date filter, but I'm not avble to do so in Qlikview Script window. Date Format in Source Database is "3/25/2012 11:07:00 AM". I want to pull all records from 1st Jan 2013. Please advise..........
SQL: SELECT "ACK_DATE","BOX_NO","BOX_SHIP_DATE",FROM "ABC_DB"."ORDER_DETAIL" Where "ENTRY_DATE">= '1/1/2013 00:01:00 AM';
You probably have to use the to_date() function to create a date from the string:
SELECT "ACK_DATE","BOX_NO","BOX_SHIP_DATE" FROM "ABC_DB"."ORDER_DETAIL" Where "ENTRY_DATE">= to_date('1/1/2013 00:01:00 AM','M/D/YYYY hh:mi:ss AM');
You probably have to use the to_date() function to create a date from the string:
SELECT "ACK_DATE","BOX_NO","BOX_SHIP_DATE" FROM "ABC_DB"."ORDER_DETAIL" Where "ENTRY_DATE">= to_date('1/1/2013 00:01:00 AM','M/D/YYYY hh:mi:ss AM');
After the SQL statement the SELECT sentence is compiled for the provider (Oracle)
So you need to do something like that:
SQL SELECT ACK_DATE,BOX_NO,BOX_SHIP_DATE
FROM ABC_DB.ORDER_DETAIL
Where ENTRY_DATE>= '20130101';
Hi Eddy, tried your sujjestions but I'm getting an error message:
"SQL##f - SqlState: S1000, ErrorCode: 1861, ErrorMsg: [Oracle][ODBC][Ora]ORA-01861: literal does not match format string"
I get this error Message:
"SQL##f - SqlState: S1000, ErrorCode: 1821, ErrorMsg: [Oracle][ODBC][Ora]ORA-01821: date format not recognized"
Hi All, tried the below mentioned format and its working Now:
* Where ENTRY_DATE>= TO_DATE('2013-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')