Treehouse | Community | Formatting Dates and Times

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

Join our Live Career-Building Workshop: Launch Your Tech-Adjacent Career! ⭐ 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

Rachel Waybill
1,393 Points
I don't understand what this is supposed to be.

Posted July 30, 2024 7:11pm by Rachel Waybill

Rachel Waybill
1,393 Points
1 Answer
Grace BakerWhitcomb
1,296 Points
Help with query please

Posted February 28, 2024 4:50am by Grace BakerWhitcomb

Grace BakerWhitcomb
1,296 Points
2 Answers
ashwathh
3,129 Points
how to format date in mm/yyyy format in SQL?

Posted June 27, 2023 12:10am by ashwathh

ashwathh
3,129 Points
1 Answer
Brian Taylor
3,436 Points
Your code challenge appears to have a broken Javascript file in it? (or at least in this instance of the virtual machine

Posted January 26, 2023 6:57am by Brian Taylor

Brian Taylor
3,436 Points
1 Answer
Spencer Lebel
3,125 Points
Need helping finding the Count of ordered_on today.

Posted October 18, 2022 10:44pm by Spencer Lebel

Spencer Lebel
3,125 Points
1 Answer
Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
Help With Reporting WITH SQL

Posted September 30, 2022 2:26pm by Geovani Mejia

Geovani Mejia
Front End Web Development Techdegree Student 7,940 Points
1 Answer
Katie Martens
1,962 Points
Counting orders from yesterday from an ecommerce database

Posted May 9, 2022 8:05pm by Katie Martens

Katie Martens
1,962 Points
3 Answers
Amanda Hawley
1,774 Points
strftime

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

Amanda Hawley
1,774 Points
1 Answer
Alessandro Pappacena
2,589 Points
Wrong count calculation

Posted May 23, 2021 10:31pm by Alessandro Pappacena

Alessandro Pappacena
2,589 Points
1 Answer
Brian Diaz
2,819 Points
What am I missing?

Posted April 14, 2021 1:07am by Brian Diaz

Brian Diaz
2,819 Points
1 Answer
Anastasia Lynn-Smith
1,773 Points
Date challenge - what am I doing wrong?

Posted March 9, 2021 12:21pm by Anastasia Lynn-Smith

Anastasia Lynn-Smith
1,773 Points
2 Answers
Roxanne Reyes
9,006 Points
My query is correct, but why is it still throwing an error?

Posted January 28, 2021 2:52pm by Roxanne Reyes

Roxanne Reyes
9,006 Points
1 Answer
Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
I am getting the answer expected the count to be 14....

Posted October 30, 2020 6:49pm by Jason Nutt

Jason Nutt
Front End Web Development Techdegree Graduate 24,760 Points
2 Answers
Lyola Rowe
3,806 Points
Please help with this challenge

Posted October 29, 2020 5:27am by Lyola Rowe

Lyola Rowe
3,806 Points
1 Answer
Lyola Rowe
3,806 Points
Please help understand what I'm doing wrong here

Posted October 29, 2020 4:54am by Lyola Rowe

Lyola Rowe
3,806 Points
1 Answer
William Hallam
2,948 Points
Query doesn't seem to work and I cannot figure out why not.

Posted October 27, 2020 11:22am by William Hallam

William Hallam
2,948 Points
1 Answer
Lyola Rowe
3,806 Points
Need help with this query

Posted October 27, 2020 4:32am by Lyola Rowe

Lyola Rowe
3,806 Points
2 Answers
Talon Ward
2,495 Points
This one is really confusing

Posted October 11, 2020 3:48pm by Talon Ward

Talon Ward
2,495 Points
1 Answer
Talon Ward
2,495 Points
Am I using the count function correctly here?

Posted October 9, 2020 4:52am by Talon Ward

Talon Ward
2,495 Points
1 Answer
Lucio Bonforte
4,164 Points
I need help please. What am I doing wrong?

Posted October 8, 2020 3:11pm by Lucio Bonforte

Lucio Bonforte
4,164 Points
2 Answers
devis
4,059 Points
Where are the solutions for the workspace practice sessions of each of the 4 chapters of the course?

Posted August 21, 2020 10:39am by devis

devis
4,059 Points
0 Answers
Todd Hamblen
4,523 Points
What type system is this supposed to be ran on?

Posted July 20, 2020 4:36pm by Todd Hamblen

Todd Hamblen
4,523 Points
1 Answer
Matt Fuller
2,395 Points
Is Order Count w/ Date Challenge Still Flawed?

Posted July 3, 2020 5:53pm by Matt Fuller

Matt Fuller
2,395 Points
1 Answer
Caleb Newell
12,562 Points
Help with sql date

Posted May 19, 2020 12:16pm by Caleb Newell

Caleb Newell
12,562 Points
1 Answer
Rahul Kasam
3,080 Points
I have used my notes for the dates chapter practice session. Is it okay if I use my notes for solving a question or not?

Posted May 10, 2020 3:08am by Rahul Kasam

Rahul Kasam
3,080 Points
1 Answer
walter fernandez
4,992 Points
can some one please give me the solution?

Posted April 3, 2020 10:40pm by walter fernandez

walter fernandez
4,992 Points
1 Answer
Arush Sharma
2,513 Points
This is the error message when I try to execute my query - " Your query retrieve the dates in the correct format (%m/%Y)

Posted January 22, 2020 12:43pm by Arush Sharma

Arush Sharma
2,513 Points
0 Answers
Mohd Aamir Mir
3,281 Points
select title,STRFTIME(%m%y,date_released) as month_year_released from movies;

Posted January 20, 2020 7:18am by Mohd Aamir Mir

Mohd Aamir Mir
3,281 Points
1 Answer
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
Jerry Lombardo
945 Points
Date Datatypes Task

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

Jerry Lombardo
945 Points
4 Answers

Prev Page 1 of 3 Next

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