• Home
  • Free Trial
  • Sign In
  • Plans
  • Tracks
  • Library
  • Community
  • Support
  • Jobs
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
  • Amanda Hawley
    Amanda Hawley
    1,774 Points

    strftime

    Posted October 18, 2021 9:42pm by Amanda Hawley
    Amanda Hawley
    1,774 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    1 Answer

  • Brian Diaz
    Brian Diaz
    2,819 Points

    What am I missing?

    Posted April 14, 2021 1:07am by Brian Diaz
    Brian Diaz
    2,819 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    1 Answer

  • Roxanne Reyes
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    1 Answer

  • Lyola Rowe
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    1 Answer

  • Talon Ward
    Talon Ward
    2,495 Points

    This one is really confusing

    Posted October 11, 2020 3:48pm by Talon Ward
    Talon Ward
    2,495 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    1 Answer

  • Lucio Bonforte
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    2 Answers

  • Arush Sharma
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    0 Answers

  • Mohd Aamir Mir
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    1 Answer

  • Stephanie Albright
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    2 Answers

  • Jerry Lombardo
    Jerry Lombardo
    945 Points

    Date Datatypes Task

    Posted November 14, 2019 9:49pm by Jerry Lombardo
    Jerry Lombardo
    945 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    4 Answers

  • Jonathan Freire-Benites
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    3 Answers

  • Luke Otto
    Luke Otto
    1,348 Points

    STRFTIME Question Issue

    Posted July 7, 2019 10:44pm by Luke Otto
    Luke Otto
    1,348 Points
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    1 Answer

  • Deborah Watson
    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
    • Databases
    • Reporting with SQL
    • Date and Time Functions
    • Formatting Dates and Times

    3 Answers

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

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Perks
  • Public Library Access
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2023 Treehouse Island, Inc.