Treehouse | Community | Formatting Dates and Times

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

Join our free workshop and get a Treehouse discount code! 💼 Register here!

New No-Code Track! 🚀 New videos dropping every week—start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Amanda Hawley
1,774 Points
strftime

Posted October 18, 2021 9:42pm by Amanda Hawley

Amanda Hawley
1,774 Points
1 Answer
Jose Testa
2,051 Points
How to replace just one character "@" from every entry on the email column.

Posted October 18, 2021 4:13pm by Jose Testa

Jose Testa
2,051 Points
2 Answers
Danial Syafiq
9,168 Points
error on challenge 3

Posted October 14, 2021 4:11pm by Danial Syafiq

Danial Syafiq
9,168 Points
1 Answer
Jose Testa
2,051 Points
How to find the length of a value

Posted October 14, 2021 4:08pm by Jose Testa

Jose Testa
2,051 Points
1 Answer
Joshua Goss
5,714 Points
My SQL query is not being accepted and I don't know why.

Posted October 14, 2021 12:51am by Joshua Goss

Joshua Goss
5,714 Points
1 Answer
xczurymqdj
2,289 Points
what is a condition again?

Posted October 12, 2021 11:29pm by xczurymqdj

xczurymqdj
2,289 Points
3 Answers
Jose Testa
2,051 Points
Selecting a column so that all the rows would appear between <> operators.

Posted October 12, 2021 1:38pm by Jose Testa

Jose Testa
2,051 Points
2 Answers
Em Noble
6,979 Points
what is wrong with my code?

Posted October 10, 2021 1:13am by Em Noble

Em Noble
6,979 Points
1 Answer
Christopher Carey
151 Points
Can you explain how the answer data type is incorrect?

Posted October 5, 2021 10:27pm by Christopher Carey

Christopher Carey
151 Points
1 Answer
João Mendonça
2,793 Points
Stuck on SQL question, did I not SELECT?

Posted October 4, 2021 11:36am by João Mendonça

João Mendonça
2,793 Points
1 Answer
Garrett Harriman
4,171 Points
Cannot Pass Challenge 2 of 6: SQL Set Operations Review (Fruit and Vegetables)

Posted September 28, 2021 11:50pm by Garrett Harriman

Garrett Harriman
4,171 Points
2 Answers
jeehry
11,575 Points
SELECT * FROM books WHERE genre LIKE Fantasy ORDER BY first_published LIMIT 5 ASC

Posted September 19, 2021 2:26am by jeehry

jeehry
11,575 Points
2 Answers
JAVIER MATHEU
19,456 Points
Why my answer is not correct?

Posted September 14, 2021 6:21pm by JAVIER MATHEU

JAVIER MATHEU
19,456 Points
1 Answer
Tyler Young
1,581 Points
SQL Playground says ILIKE is an error

Posted September 13, 2021 9:31pm by Tyler Young

Tyler Young
1,581 Points
1 Answer
Tyler Young
1,581 Points
Why can't I use aliases for this query, following an example where first_name can be presented as "First Name"?

Posted September 10, 2021 8:03pm by Tyler Young

Tyler Young
1,581 Points
0 Answers
Fahad Ahsan
2,595 Points
SELECT JOBS.ROLE, COUNT(1) FROM EMPLOYEES JOIN JOBS ON EMPLOYEES.JOB_ID = JOBS.ID ;

Posted September 8, 2021 12:18pm by Fahad Ahsan

Fahad Ahsan
2,595 Points
1 Answer
Fahad Ahsan
2,595 Points
Stuck on challenge 2 I have this so far

Posted September 7, 2021 5:56pm by Fahad Ahsan

Fahad Ahsan
2,595 Points
1 Answer
Elise Lawrence
4,844 Points
SQL ORMs with Node.js - Unhandled Promise Rejection

Posted September 5, 2021 9:58am by Elise Lawrence

Elise Lawrence
4,844 Points
- Databases
0 Answers
chris muhirwa
1,112 Points
need help with the code challenge

Posted September 2, 2021 5:17am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
chris muhirwa
1,112 Points
need help answering the question

Posted September 2, 2021 4:48am by chris muhirwa

chris muhirwa
1,112 Points
0 Answers
chris muhirwa
1,112 Points
need help figuring out what am missing in my code

Posted September 2, 2021 3:09am by chris muhirwa

chris muhirwa
1,112 Points
1 Answer
Yeshaya Coffman
Full Stack JavaScript Techdegree Graduate 22,885 Points
Trying to install sqlite3 on a raspberry pi

Posted August 29, 2021 11:29pm by Yeshaya Coffman

Yeshaya Coffman
Full Stack JavaScript Techdegree Graduate 22,885 Points
- Databases
1 Answer
Holly Bancroft
5,162 Points
Dates in SQL

Posted August 22, 2021 11:20am by Holly Bancroft

Holly Bancroft
5,162 Points
1 Answer
J de la Torre
2,858 Points
Difference in speed/efficiency between CTEs, INTERSECT, WHERE clause solutions?

Posted August 4, 2021 7:04pm by J de la Torre

J de la Torre
2,858 Points
1 Answer
Kate Johnson
Python Development Techdegree Graduate 20,155 Points
I don't understand what is wrong with my code here. [solved]

Posted July 25, 2021 8:35pm by Kate Johnson

Kate Johnson
Python Development Techdegree Graduate 20,155 Points
1 Answer
Michael Reta
255 Points
How do I query to find all of the rows with missing data without individually typing out each column name?

Posted July 25, 2021 6:09pm by Michael Reta

Michael Reta
255 Points
1 Answer
Andy McDonald
Python Development Techdegree Graduate 13,801 Points
how to find values outside of a given range in SQL

Posted July 24, 2021 5:32am by Andy McDonald

Andy McDonald
Python Development Techdegree Graduate 13,801 Points
1 Answer
Özgür Yildirim
4,088 Points
What is wrong with this query?

Posted July 17, 2021 8:39pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
1 Answer
Özgür Yildirim
4,088 Points
Task 4 of 4 is driving me mad. Obviously I do not get it

Posted July 17, 2021 8:33pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers
Özgür Yildirim
4,088 Points
My subquery doesn't return all CustomerIDs for people who identify as female (F), apparently. But why?

Posted July 17, 2021 7:47pm by Özgür Yildirim

Özgür Yildirim
4,088 Points
0 Answers

Prev Page 7 of 389 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.