SQL generate_series, dayofweek(DOW), weekday, functions

SQL

https://www.codewars.com/kata/58241d05e7a162c5b100010f/train/sql

-- Replace with your code
CREATE OR REPLACE FUNCTION weekdays(DATE,DATE)
  RETURNS INTEGER AS
$func$
SELECT COUNT(*)
FROM GENERATE_SERIES(LEAST($1,$2),GREATEST($1,$2),'1d') AS days
WHERE EXTRACT(ISODOW FROM days) < 6
$func$
LANGUAGE sql;
changjulian17
Did you find this snippet useful?

Sign up for free to to add this to your code library

Getting the Last Record Using Rank Function - T-SQL Example
SQL

T-SQL

40
Getting the Date for the Previous Saturday with T-SQL
SQL

T-SQL

29
Remove Leading Zeros from a Field with T-SQL
SQL

T-SQL | Data Cleaning

8
left join LATERAL
SQL

6
median
SQL

5
SQL window function II: percent growth
SQL

5
SQL RANK
SQL

5
EXISTS
SQL

4
SQL creating a view
SQL

4
SQL window function
SQL

4