Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Matt Fuller
1,067 Points
Is Order Count w/ Date Challenge Still Flawed?

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

Matt Fuller
1,067 Points
0 Answers
Caleb Newell
5,248 Points
Help with sql date

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

Caleb Newell
5,248 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,991 Points
can some one please give me the solution?

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

walter fernandez
4,991 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
Luke Otto
1,348 Points
STRFTIME Question Issue

Posted July 7, 2019 10:44pm by Luke Otto

Luke Otto
1,348 Points
1 Answer
Felix Belga
4,267 Points
I cannot see what is wrong with my code

Posted May 16, 2019 6:55pm by Felix Belga

Felix Belga
4,267 Points
3 Answers
Chamundeshwari Vadamalai
2,204 Points
How to format the dates?

Posted April 2, 2019 11:46am by Chamundeshwari Vadamalai

Chamundeshwari Vadamalai
2,204 Points
1 Answer
Namazbek Bekarysuly
882 Points
What is wrong?

Posted February 23, 2019 4:03pm by Namazbek Bekarysuly

Namazbek Bekarysuly
882 Points
1 Answer
dfeem
4,660 Points
Looking for help on this challenge?

Posted February 17, 2019 12:19am by dfeem

dfeem
4,660 Points
2 Answers
Michael Nanni
7,355 Points
What exactly am I counting?

Posted January 29, 2019 1:29pm by Michael Nanni

Michael Nanni
7,355 Points
0 Answers
Mark Chesney
11,679 Points
february 31

Posted January 12, 2019 5:20am by Mark Chesney

Mark Chesney
11,679 Points
0 Answers
Kevin Gates
14,770 Points
So if you have a date + time, and you add a year, won't the result be a date + time? I thought you had to use STRFTIME?

Posted January 7, 2019 4:53pm by Kevin Gates

Kevin Gates
14,770 Points
1 Answer
David Corrales
4,651 Points
Wow, I keep getting stumped! This might not be for me! I'm trying hard though, this challenge is kicking my butt!

Posted December 17, 2018 12:51am by David Corrales

David Corrales
4,651 Points
1 Answer
David Corrales
4,651 Points
Hi Community! Sorry to be a bother! =[ This challenge is stumping me!

Posted December 17, 2018 12:38am by David Corrales

David Corrales
4,651 Points
1 Answer
Shain Jones
1,230 Points
Calculating Dates

Posted October 26, 2018 6:10pm by Shain Jones

Shain Jones
1,230 Points
2 Answers
Rose Mathurin
2,882 Points
What am i doing wrong?

Posted October 20, 2018 8:02am by Rose Mathurin

Rose Mathurin
2,882 Points
1 Answer
Fairooz Adams
2,704 Points
What to do here?

Posted October 14, 2018 8:07pm by Fairooz Adams

Fairooz Adams
2,704 Points
2 Answers
Karen Shumate
13,579 Points
Count the total number of orders that were ordered yesterday and have the status of 'shipped'. Alias it to ordered_yeste

Posted September 30, 2018 8:21pm by Karen Shumate

Karen Shumate
13,579 Points
1 Answer
Courage Tafadzwa Chesa
5,308 Points
Does this code work lol im now stuck

Posted September 17, 2018 1:29pm by Courage Tafadzwa Chesa

Courage Tafadzwa Chesa
5,308 Points
0 Answers
Gurdeep singh
1,522 Points
SELECT COUNT(*) AS "ordered_yesterday_and_shipped" FROM orders WHERE status = "shipped" AND ordered_on = DATE("now", -1)

Posted August 30, 2018 3:29am by Gurdeep singh

Gurdeep singh
1,522 Points
2 Answers
Robbie Thomas
31,092 Points
Today's Report challenge

Posted August 7, 2018 3:32pm by Robbie Thomas

Robbie Thomas
31,092 Points
1 Answer
david vo
3,278 Points
reporting with sql

Posted July 25, 2018 9:37pm by david vo

david vo
3,278 Points
3 Answers
Felix Bynum
1,129 Points
Issues with dates, particularly "now"

Posted July 6, 2018 6:53pm by Felix Bynum

Felix Bynum
1,129 Points
1 Answer
Deborah Watson
2,614 Points
STRFTIME() Bummer: You may have got your params the wrong way around.

Posted June 21, 2018 5:07pm by Deborah Watson

Deborah Watson
2,614 Points
3 Answers

Prev Page 1 of 2 Next

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