Hi Folks,
I've requirement to show the week number as ww format. Please see the below code
select weekofyear(date_add(to_date(current_date, 'yyyyMMdd'), +35)). also plz refre the screen shot for result.
Hi Folks,
I've requirement to show the week number as ww format. Please see the below code
select weekofyear(date_add(to_date(current_date, 'yyyyMMdd'), +35)). also plz refre the screen shot for result.