python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - lpad

SQL Query a table and use LPAD for one column with dtype (smallint) to return values with leading 0's

There's about 25 columns and I want to query them all while formatting this one column to include leading zeros. i.e julianday = 5 I want the data to show 005 julianday = 145 I want the data to show 1...
test-img

Number1Rock

sql

teradata-sql-assistant

lpad

Votes: 0

Answers: 1

Latest Answer

The first parameter in lpad needs to be a string so you would have to cast the date to a string, in the required format, before you can use it in lpad
test-img

NickW

Posts

Questions

Blogs

Jobs