Leading zero infront of row

Question

I have this column called Week, that is a number. Instead of displaying it like week 1,2,3,4 etc i want to display with a 0 in front. I am working in Oracle Database.

The view is constructed as following:

Select "DATO","UGEDAG","WEEK","MÅNED","ÅR","KVARTAL","MÅNEDNUMMER","MÅNEDNUMMERTAL" 
from SC_DRIFT.EXCEL_DATO_UGE 
where DATO >= '2016-01-01'

Basically the same thing as described [here](https://stackoverflow.com/questions/16760900/pad-a-string-with-leading-zeros-so-its-3-characters-long-in-sql-server-2008) but translated in PL-SQL — Geert Bellekens, Dec 21 '18 at 10:15

score 0 · Answer 1 · answered Dec 21 '18 at 10:14

0

You can try below - using lpad() function

Select "DATO","UGEDAG",LPAD("WEEK", 2, '0'),"MÅNED","ÅR","KVARTAL","MÅNEDNUMMER","MÅNEDNUMMERTAL" 
from SC_DRIFT.EXCEL_DATO_UGE 
where DATO >= '2016-01-01'

answered Dec 21 '18 at 10:14

Fahmi

37,315
5
22
31

Tim Biegeleisen · Answer 2 · 2018-12-21T10:16:59.943

0

You could use TO_CHAR:

SELECT
    "DATO",
    "UGEDAG",
     SUBSTR('0' || TO_CHAR(WEEK), -2, 2) AS "WEEK",
    "MÅNED",
    "ÅR",
    "KVARTAL",
    "MÅNEDNUMMER",
    "MÅNEDNUMMERTAL" 
FROM SC_DRIFT.EXCEL_DATO_UGE 
WHERE DATO >= '2016-01-01';

edited Dec 21 '18 at 10:16

answered Dec 21 '18 at 10:14

Tim Biegeleisen

502,043
27
286
360

I suppose OP wants that leading 0 for week 1 to 9 only. – jarlh Dec 21 '18 at 10:15
@jarlh Answer updated, thanks for the feedback. – Tim Biegeleisen Dec 21 '18 at 10:17
Thanks, that worked like a charm. – J. A. Dec 21 '18 at 10:17
How do i solve this as jarlh said for only week 1 to 9 – J. A. Dec 21 '18 at 10:20
Reload your page, I fixed it. – Tim Biegeleisen Dec 21 '18 at 10:21
Yes, I see. Thank you! – J. A. Dec 21 '18 at 10:23

Leading zero infront of row

2 Answers2