Need Help

1062978

Need help - I use APEX and I am have a file in DWH that I can call using SQL however I only want records returned when the DWH_CDATE = todays date but I ....this is what I have written "SELECT * FROM BBT_SHF.RDN where DWH_CDATE,''YYYY-MM-DD'') =sysdate

Mannamal-Oracle

This is the wrong forum for your question.  Try the APEX forum at https://community.oracle.com/community/developer/english/oracle_database/application_express

vincent_deelen

Cast sysdate to the date format of your choise:

select *

from   dbbt_shf.RDN

where to_date(dwh_cdate,'yyyy-mm-dd') = to_date(sysdate,'yyyy-mm-dd')

Regards,

Vincent

http://vincentdeelen.blogspot.com

Mike Kutz

close, but wrong.

Do not do an implicit date to string to date conversion.

Your code will easily break as soon as someone changes the NLS_DATE_FORMAT parameter.

sysdate is already in DATE format.  You just need to TRUNCate it.

where to_date(dwh_cdate,'yyyy-mm-dd') = trunc( sysdate );

-- this is assuming DWH_CDATE is a varchar2 not a DATE format.

if it is a DATE, you may need to truncate both.

where trunc( dwh_cdate ) = trunc( sysdate );

Don't forget to create an FBI or you'll get a full table scan.

MK