Treehouse | Community | Formatting Dates and Times

Don't forget to gift yourself this Cyber Monday 👀 Get a year of Courses for $150 (40% off!)

💥 ALL NEW: Code Adventures! ⚡ Dare to embark on a front end coding adventure 🌟

Dive into new course Game Development with Phaser 👾

New AI course: Introduction to Computer Vision 💻

Learn about our new Community Discord server here and join us on Discord here!

New workshop: Discover AI-powered VS Code extensions like GitHub Copilot and IntelliCode 🤖

New course! Join Dan as he uses generative AI to design a website for a bakery 🥖

Jump into our new React Basics course 😎

Get job-ready with our Career Toolbox Track's career advice, resume tips, and more 🧰

Learn about our new Community Discord server here and join us on Discord here!

🤖 Check out all our AI content here 👀

Students: got a cool project or resource to share? Submit it to Treehouse Links! 🤩

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

ashwathh
1,793 Points
how to format date in mm/yyyy format in SQL?

Posted June 27, 2023 12:10am by ashwathh

ashwathh
1,793 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,803 Points
Please help with this challenge

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

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

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

Lyola Rowe
3,803 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,803 Points
Need help with this query

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

Lyola Rowe
3,803 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
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
Jonathan Freire-Benites
2,234 Points
date format not accepted despite being correct

Posted August 31, 2019 8:07pm by Jonathan Freire-Benites

Jonathan Freire-Benites
2,234 Points
3 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.