Zerofill weekofyear function 1

[aalnaif]

I am using the built-in SQL weekofyear function, which returns a value between 1 and 52. My problem is I want the returned value to always be two digits (e.g. 01 instead of 1). Does anyone know how to do this?

 

[r937]

cast it to VARCHAR, append it to the character '0', then take the last two characters using the RIGHT function

overlooking, of course, that RIGHT isn't an ANSI SQL function



r937.com | rudy.ca

 

[aalnaif]

r937,

I'm not exactly sure what you mean by casting and appending. My code looks like this:

Select weekofyear(examination_date) as exam_week
from main_table

Would you be able to rewrite this code so that the exam_week column always contains two digits? Thank you.

 

[r937]

which dbms, please?

r937.com | rudy.ca

 

[aalnaif]

MySQL

 

[r937]

select right(concat('0',weekofyear(examination_date)),2)
as exam_week


r937.com | rudy.ca

 

[aalnaif]

Thanks r937, that's exactly what I was looking for! I see what you meant now in your first comment. That's very smart algorithm!

 

[JarlH]

The keyword ALL <> *

INTO is not PART of the SELECT statement as described here.

 

[JarlH]

Oops, disregard my posting above, wrong thread!

(This is a reason NOT to read multiple threads in different Firefox tabs...)