Skip to main content

Hi,

 

I’d like to put a date range for my SQL statement. Could you please advise?

 

SELECT 
payment_address.Identity,
SUPPLIER_INFO_GENERAL.Name,
payment_address.Party_Type,
payment_address.Way_ID,
supplier_info_general.creation_date,
payment_address.Description,
payment_address.Default_Address,
payment_address.Data1,
payment_address.Account


FROM   payment_address
FULL JOIN SUPPLIER_INFO_GENERAL
ON payment_address.IDENTITY = SUPPLIER_INFO_GENERAL.SUPPLIER_ID

It will usually be something like this….

 

and date_applied between to_date('&m-C-BL]Start_Date_Range', 'YYYYMMDD') and
       to_date('&(-C-BL]End_Date_Range', 'YYYYMMDD') + (1 - 1 / (60 * 60 * 24))

It works. Thanks!

Reply


Terms & ConditionsCookie settings