Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have a table from SQL database
Here the DATE is in DD/MM/YYYY 00:00:00 format. so extracted date with DD/MM/YYYY using to_char function.
By using where condition I have to extract only 2 days data 02/04/2018 and 03/04/2018 and need to store in one qvd only. By defining static also fine.
i have used like this and extracted one day data using where to_Char(DATE,'DD/MM/YYYY') ='02/02/2018';
how to add 03/04/2018 here. Please help me on this
LOAD
DATE(DATE,'DD/MM/YYYY') as DATE,
TYPE,
STATUS,
SALES,
PRODUCT;
SELECT
to_Char(DATE,'DD/MM/YYYY') AS DATE,
TYPE,
STATUS,
SALES,
PRODUCT
FROM ....
where to_Char(DATE,'DD/MM/YYYY') ='02/02/2018';
SELECT
to_Char(DATE,'DD/MM/YYYY') AS DATE,
TYPE,
STATUS,
SALES,
PRODUCT
FROM ....
where to_Char(DATE,'DD/MM/YYYY') Between '02/02/2018' AND '03/04/2018';
Use in() or between() in where clause
like
select * from tableName
where dateField in ('requiredDate','requiredDate')
or
select * from tableName
where dateField between 'FromDate' and 'toDate'
Regards,
Hi,
Use where DATE >='02/02/2018' and <='03/02/2018'
Regards
SELECT
to_Char(DATE,'DD/MM/YYYY') AS DATE,
TYPE,
STATUS,
SALES,
PRODUCT
FROM ....
where to_Char(DATE,'DD/MM/YYYY') Between '02/02/2018' AND '03/04/2018';
have you got this working?
SELECT
to_Char(DATE,'DD/MM/YYYY') AS DATE,
TYPE,
STATUS,
SALES,
PRODUCT
FROM ....
where to_Char(DATE,'DD/MM/YYYY') ='02/04/2018'
OR to_Char(DATE,'DD/MM/YYYY') ='03/04/2018';