Treehouse | Community | Formatting Dates and Times

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

Join our Live Career-Building Workshop: Fast-Track Your Tech Career Without a Degree! ⭐ Register here!

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Stephanie Albright
5,690 Points
Can't find my syntax error.

Posted January 14, 2020 10:21pm by Stephanie Albright

Stephanie Albright
5,690 Points
2 Answers
Mohd Aamir Mir
3,281 Points
select email from customers where REPLACE(email,"@","<at>") as obfuscated_email;

Posted January 11, 2020 8:12pm by Mohd Aamir Mir

Mohd Aamir Mir
3,281 Points
1 Answer
Mohd Aamir Mir
3,281 Points
where am i wrong in writing this query?

Posted January 11, 2020 11:57am by Mohd Aamir Mir

Mohd Aamir Mir
3,281 Points
2 Answers
Stephanie Albright
5,690 Points
Help please

Posted January 10, 2020 7:14pm by Stephanie Albright

Stephanie Albright
5,690 Points
3 Answers
Maryam Naz
3,636 Points
how to combine "AS" statement so I wont have to re-type AS each time?

Posted December 31, 2019 12:51am by Maryam Naz

Maryam Naz
3,636 Points
1 Answer
Maryam Naz
3,636 Points
can someone define "string literal" and identifier"? I tried the web, and still unclear. Thanks in advance.

Posted December 30, 2019 10:58pm by Maryam Naz

Maryam Naz
3,636 Points
2 Answers
Charles Fields
4,205 Points
Has anyone been able to satisfy the question of querying to this format? Andrew Chalkley <andrew@teamtreehouse.com>

Posted December 19, 2019 8:19pm by Charles Fields

Charles Fields
4,205 Points
1 Answer
Fredrick Adegoke
1,983 Points
Unsure why my query is failing

Posted December 11, 2019 10:28am by Fredrick Adegoke

Fredrick Adegoke
1,983 Points
1 Answer
Riley Egan
2,452 Points
I'm at a loss as far as what to do. I've re-watched the video several times and cannot get past this point.

Posted November 20, 2019 7:47pm by Riley Egan

Riley Egan
2,452 Points
2 Answers
Jessica Schteiden
3,254 Points
Issue with Concatenation Function

Posted November 16, 2019 4:43am by Jessica Schteiden

Jessica Schteiden
3,254 Points
1 Answer
Jerry Lombardo
945 Points
Date Datatypes Task

Posted November 14, 2019 9:49pm by Jerry Lombardo

Jerry Lombardo
945 Points
4 Answers
Jerry Lombardo
945 Points
Getting the Grand Total exercise

Posted November 1, 2019 9:36pm by Jerry Lombardo

Jerry Lombardo
945 Points
1 Answer
Jerry Lombardo
945 Points
Count Challenge Task 1

Posted October 29, 2019 7:15pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
Duane McAllister
2,858 Points
Am I doing something wrong with how I'm coding

Posted October 25, 2019 8:02pm by Duane McAllister

Duane McAllister
2,858 Points
1 Answer
Jerry Lombardo
945 Points
Concatenation

Posted October 24, 2019 9:12pm by Jerry Lombardo

Jerry Lombardo
945 Points
2 Answers
Kimberlee Johnson
5,343 Points
Small typo in "Changine" questions (SQL Playground - Stage 2 Practice)?

Posted October 23, 2019 5:47pm by Kimberlee Johnson

Kimberlee Johnson
5,343 Points
1 Answer
juannie jimenez
2,859 Points
trying to figure out why my answer is wrong concatenating these columns and Alias it to to_field

Posted October 22, 2019 7:15pm by juannie jimenez

juannie jimenez
2,859 Points
1 Answer
Steve Rogers
3,285 Points
Problem with code

Posted October 21, 2019 9:14pm by Steve Rogers

Steve Rogers
3,285 Points
3 Answers
Casey Fulmore
1,853 Points
I'm not sure why I'm getting an error when trying to run this code. My notes show that this should be accurate.

Posted October 8, 2019 3:36pm by Casey Fulmore

Casey Fulmore
1,853 Points
2 Answers
Orchid Li
2,024 Points
In the library database there's a patrons table with the columns id, first_name, last_name, address, email, library_id,

Posted October 7, 2019 7:02pm by Orchid Li

Orchid Li
2,024 Points
2 Answers
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
Could someone pls tell me whats wrong with this statement.

Posted October 2, 2019 7:39pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
4 Answers
Sharim Babar
2,647 Points
My result looks like the example but it is still wrong, why is that?

Posted September 30, 2019 8:27pm by Sharim Babar

Sharim Babar
2,647 Points
1 Answer
Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
Please help me with the syntax for this SQL statement.

Posted September 28, 2019 8:28pm by Shreemangal Sethi

Shreemangal Sethi
Full Stack JavaScript Techdegree Student 15,552 Points
2 Answers
newtocoding
4,940 Points
How to answer this challenge?

Posted September 25, 2019 12:17pm by newtocoding

newtocoding
4,940 Points
2 Answers
Zach Johnston
2,500 Points
I'm not sure how this isn't pulling the correct count. SELECT COUNT(genre) AS genre_count FROM books GROUP BY genre

Posted September 16, 2019 10:43pm by Zach Johnston

Zach Johnston
2,500 Points
1 Answer
Luigi Cinque
1,548 Points
SQL (ORDER BY, WHERE)

Posted September 15, 2019 9:36pm by Luigi Cinque

Luigi Cinque
1,548 Points
2 Answers
Unsubscribed User
8,428 Points
Not sure what I am missing, eyes going crossed. If you can help me see the invisible I would be grateful.

Posted September 13, 2019 3:13pm by Unsubscribed User

Unsubscribed User
8,428 Points
1 Answer
Omar Nousseir
2,262 Points
What is wrong with this SQL query ? SELECT COUNT(*) FROM orders WHERE status = "shipped" AND ordered_on = DATE("now");

Posted September 7, 2019 11:33pm by Omar Nousseir

Omar Nousseir
2,262 Points
1 Answer
Miles Eastwood
1,682 Points
How to concatenate and use an alias at the same time?

Posted September 7, 2019 3:35pm by Miles Eastwood

Miles Eastwood
1,682 Points
1 Answer
Carol Garcia
1,875 Points
Second attempt.

Posted September 2, 2019 6:59pm by Carol Garcia

Carol Garcia
1,875 Points
1 Answer

Prev Page 8 of 18 Next

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