This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Practise SQL in your browser with SQL Fiddle Part ten of a sixteen-part series of blogs
Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer! Installing and configuring SQL Fiddle SQL Fiddle Exercise 1 - SELECT SQL Fiddle Exercise 2 - Order By SQL Fiddle Exercise 3 - Numeric Filters SQL Fiddle Exercise 4 - Date Filter SQL Fiddle Exercise 5 - Text Filters SQL Fiddle Exercise 6 - Cast or Convert Functions SQL Fiddle Exercise 7 - Conditional Function SQL Fiddle Exercise 8 - Counting Words SQL Fiddle Exercise 9 - Formatted Dates (this blog) SQL Fiddle Exercise 10 - Date Calculations SQL Fiddle Exercise 11 - Inner Join SQL Fiddle Exercise 12 - Outer Join SQL Fiddle Exercise 13 - Grouping Data SQL Fiddle Exercise 14 - Having SQL Fiddle Exercise 15 - All together now!

Practise SQL in your browser with SQL Fiddle

Part ten of a sixteen-part series of blogs

Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!

Posted by Sam Lowrie on 30 June 2021

SQL Fiddle Exercise 9 - Formatted Dates

Pulling dates straight out of a database can be a little messy - especially when the column is datetime.

Out of interest the dates appear like this due to ISO 8601 which dictates that dates should be displayed starting with the largest component and ending up with the smallest (so yyyy-MM-dd hh:mm:ss).

There are two major ways to change the appearance of dates. First try using the CONVERT function:

There are lots of date codes to choose from, which can be found here. For this example you should use 105 as a number code.

This is the faster of the two options, but it is restricted to the premade list of date codes. Instead try using FORMAT to show this:

Just watch out when entering the date parts: months are denoted by M and minutes by m.

Check out the answer here.

Parts of this blog
Installing and configuring SQL Fiddle SQL Fiddle Exercise 1 - SELECT SQL Fiddle Exercise 2 - Order By SQL Fiddle Exercise 3 - Numeric Filters SQL Fiddle Exercise 4 - Date Filter SQL Fiddle Exercise 5 - Text Filters SQL Fiddle Exercise 6 - Cast or Convert Functions SQL Fiddle Exercise 7 - Conditional Function SQL Fiddle Exercise 8 - Counting Words SQL Fiddle Exercise 9 - Formatted Dates (this blog) SQL Fiddle Exercise 10 - Date Calculations SQL Fiddle Exercise 11 - Inner Join SQL Fiddle Exercise 12 - Outer Join SQL Fiddle Exercise 13 - Grouping Data SQL Fiddle Exercise 14 - Having SQL Fiddle Exercise 15 - All together now!

Parts of this blog