During Phase 1, only users who are logged in can access the AI Editor feature.

SQL Fiddle is free to use and ad-free!

Want to help us? It takes 10 seconds

Step 1: Like & Share our EFE Bulk Extensions videos

Step 2: Like & Share our EFE Bulk Insert videos

Thank

Under Development!

Fiddle History is not yet available.

We hope to make this feature available at the end of 2024.

PostgreSQL DATEDIFF equivalent

You must execute the code again to save those values in the database.

joindate	joindate_1	datediff
2014-01-01 17:00:01	2014-01-01 17:00:01	0
2014-01-01 17:00:01	2014-01-02 16:00:01	0
2014-01-01 17:00:01	2014-01-03 17:00:00	-1
2014-01-02 16:00:01	2014-01-01 17:00:01	0
2014-01-02 16:00:01	2014-01-02 16:00:01	0
2014-01-02 16:00:01	2014-01-03 17:00:00	-1
2014-01-03 17:00:00	2014-01-01 17:00:01	1
2014-01-03 17:00:00	2014-01-02 16:00:01	1
2014-01-03 17:00:00	2014-01-03 17:00:00	0

joindate	joindate_1	datediff
2014-01-01 17:00:01	2014-01-01 17:00:01	0
2014-01-01 17:00:01	2014-01-02 16:00:01	-1
2014-01-01 17:00:01	2014-01-03 17:00:00	-2
2014-01-02 16:00:01	2014-01-01 17:00:01	1
2014-01-02 16:00:01	2014-01-02 16:00:01	0
2014-01-02 16:00:01	2014-01-03 17:00:00	-1
2014-01-03 17:00:00	2014-01-01 17:00:01	2
2014-01-03 17:00:00	2014-01-02 16:00:01	1
2014-01-03 17:00:00	2014-01-03 17:00:00	0

joindate	joindate_1	datediff
2014-01-01 17:00:01	2014-01-01 17:00:01	0
2014-01-01 17:00:01	2014-01-02 16:00:01	-1
2014-01-01 17:00:01	2014-01-03 17:00:00	-2
2014-01-02 16:00:01	2014-01-01 17:00:01	1
2014-01-02 16:00:01	2014-01-02 16:00:01	0
2014-01-02 16:00:01	2014-01-03 17:00:00	-1
2014-01-03 17:00:00	2014-01-01 17:00:01	2
2014-01-03 17:00:00	2014-01-02 16:00:01	1
2014-01-03 17:00:00	2014-01-03 17:00:00	0

CREATE TABLE
INSERT 0 3