Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Arush Sharma
1,483 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
1,483 Points
0 Answers
Mohd Aamir Mir
3,149 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,149 Points
1 Answer
Stephanie Albright
5,124 Points
Can't find my syntax error.

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

Stephanie Albright
5,124 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
2,391 Points
I cannot see what is wrong with my code

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

Felix Belga
2,391 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
6,127 Points
What exactly am I counting?

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

Michael Nanni
6,127 Points
0 Answers
Mark Chesney
11,671 Points
february 31

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

Mark Chesney
11,671 Points
0 Answers
Kevin Gates
14,724 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,724 Points
1 Answer
David Corrales
4,646 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,646 Points
1 Answer
David Corrales
4,646 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,646 Points
1 Answer
Shain Jones
1,151 Points
Calculating Dates

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

Shain Jones
1,151 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,091 Points
Today's Report challenge

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

Robbie Thomas
31,091 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
Hanna Han
4,104 Points
Capital Y for years in STRFTIME function

Posted June 21, 2018 5:17am by Hanna Han

Hanna Han
4,104 Points
1 Answer
Ali Ahmadian
11,474 Points
what im doing wrong?please Help!

Posted May 22, 2018 8:56pm by Ali Ahmadian

Ali Ahmadian
11,474 Points
1 Answer
Stevan Lay
8,305 Points
What is the correct syntax here?

Posted May 21, 2018 1:42am by Stevan Lay

Stevan Lay
8,305 Points
1 Answer
Terri Valentine
23,034 Points
SELECT COUNT(*) AS shipped_yesterday FROM orders WHERE status = "shipped" AND DATE("now", "-1 day")

Posted May 20, 2018 12:40am by Terri Valentine

Terri Valentine
23,034 Points
1 Answer

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.