Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
As I need a 'YYYYMM' format of date in the SQL WHERE condition.
like in our Load statement we can write
Date(MonthName(PurchaseDate),'YYYYMM') as PurchaseDate but I want the same expression in sql Where condition.
How do i write that
Hi,
If you need SQL function for it
then use
to_char(trunc(sysdate),'yyyymm')
Regards