How to make the length of the field

Question

I wrote the below SQL query to make the fiel length 40,

But I am receiving an error

to_char('IST'||' '||to_char(to_date(sysdate), 'mmyyyy'),40) des

You shouldn't apply to_date function on sysdate. It already of date datatype. — Noel, Nov 05 '13 at 09:20

score -2 · Answer 1 · answered Nov 05 '13 at 08:59

-2

Use RPAD-function:

RPAD('IST'||' '||to_char(to_date(sysdate), 'mmyyyy'),40)

answered Nov 05 '13 at 08:59

piet.t

1 Answers1