topic Re: SQL week format issue its not showing result as 01(ww) in Data Engineering

SQL week format issue its not showing result as 01(ww)

Ericsson — Wed, 01 Dec 2021 16:45:17 GMT

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.

Re: SQL week format issue its not showing result as 01(ww)

Hubert-Dudek — Wed, 01 Dec 2021 17:36:34 GMT

date_add id adding days. Today is 1st December and +35 days it gives 5th January which is first week of 2022 so result 1 is correct as returned by weekofyear function.

If you need just add leading zero the best way is to format it in visualization tool like / BI.

If you need leading zero in spark it will be have to be the string:

SELECT lpad(weekofyear(date_add(current_date, 35)), 2, '0')

It could be nice that date object is just format (date_format) as week number WW/ww but in spark is not included in date formatting: https://spark.apache.org/docs/latest/sql-ref-datetime-pattern.html

Re: SQL week format issue its not showing result as 01(ww)

Lauri — Wed, 01 Dec 2021 18:33:59 GMT

You can use lpad() to achieve the 'ww' format.

Re: SQL week format issue its not showing result as 01(ww)

Fowlkes — Sat, 24 Jan 2026 14:22:31 GMT

What Is Papa’s Freezeria?
Papa’s Freezeria is part of the famous Papa Louie game series, where players take on the role of restaurant employees running one of Papa Louie’s many eateries. http://papasfreezeria.online/