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/

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

Aidutchinso — Tue, 23 Jun 2026 09:49:04 GMT

"I've been exploring different communities lately, and honestly, connecting with people who share your interests makes all the difference. Whether it's diving deep into data engineering discussions or just having random conversations on platforms like Omegle, there's something fun about learning from strangers. You never know who you'll meet or what cool insights they'll share about tackling real-world engineering challenges!"