troubleshooting Question

SQL Query - Change date format & replace data with text conditionally

Avatar of BigBadWolf_000
BigBadWolf_000Flag for United States of America asked on
DB Reporting ToolsMicrosoft SQL Server 2008SQL
5 Comments2 Solutions784 ViewsLast Modified:
SQL Studio Manager 2008...

1- I need to change the data format output for dates in a column,
current date format is...  YYYY-MM-DD 00:00:00:000,
I need it to be YYYYMMDD
Current syntax is.... Select tmp.Dt as 'Date' from tmp Where ...etc...
I need the correct syntax

2- I need to replace data with text conditionally,
current data is......  10
I need it to be , id data is 10 then replace with Diamond
Current syntax is.... Select tmp.Sc as 'Ore' from tmp Where ...etc...
I need the correct syntax
Thank You!

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros