Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
1225. Report Contiguous Dates
--PostgreSQL 9.6 --'\\' is a delimiter drop table if exists failed; drop table if exists succeeded; Create table Failed ("fail_date" date); Create table Succeeded ("success_date" date); insert into Failed (fail_date) values ('2018-12-28'), ('2018-12-29'), ('2019-01-04'), ('2019-01-05'); insert into Succeeded (success_date) values ('2018-12-30'), ('2018-12-31'), ('2019-01-01'), ('2019-01-02'), ('2019-01-03'), ('2019-01-06');
run
|
edit
|
history
|
help
0
2
1075-1077 Project Analysis
Testing psql
Current time/date, timezone
ds
PostreSQL: Today's Date/Time
MovieRating SQL
Branch
Yandex Task
loggin_trigger-audit