add remove split language chart show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
DAY_OF_WEEK REGEXP_SUBSTR(WORKING_HOURS,'(.*?)(;|-|$)',1,(2*LEVEL-1),NULL,1) REGEXP_SUBSTR(WORKING_HOURS,'(.*?)(;|-|$)',1,2*LEVEL,NULL,1)
Friday 08:00:00 11:59:00
Friday 13:00:00 15:29:00
Monday 08:00:00 11:59:00
Monday 13:00:00 16:59:00
Saturday null null
Sunday null null
Thursday 08:00:00 11:59:00
Thursday 13:00:00 16:59:00
Tuesday 08:00:00 11:59:00
Tuesday 13:00:00 16:59:00
Wednesday 08:00:00 11:59:00
DAY_OF_WEEK WORKING_HOURS MAX_POS POS WORKING_FROM WORKING_TO
Monday 08:00:00-11:59:00;13:00:00-16:59:00; 2 1 08:00:00 11:59:00
Tuesday 08:00:00-11:59:00;13:00:00-16:59:00; 2 1 08:00:00 11:59:00
Wednesday 08:00:00-11:59:00; 1 1 08:00:00 11:59:00
Thursday 08:00:00-11:59:00;13:00:00-16:59:00; 2 1 08:00:00 11:59:00
Friday 08:00:00-11:59:00;13:00:00-15:29:00; 2 1 08:00:00 11:59:00
Saturday null null 1 null null
Sunday null null 1 null null
Monday 08:00:00-11:59:00;13:00:00-16:59:00; 2 2 13:00:00 16:59:00
Tuesday 08:00:00-11:59:00;13:00:00-16:59:00; 2 2 13:00:00 16:59:00
Thursday 08:00:00-11:59:00;13:00:00-16:59:00; 2 2 13:00:00 16:59:00
Friday 08:00:00-11:59:00;13:00:00-15:29:00; 2 2 13:00:00 15:29:00
TO_CHAR(DATE'2000-01-01'+((LEVEL-1)/48),'HH24:MI":00"')
00:00:00
00:30:00
01:00:00
01:30:00
02:00:00
02:30:00
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
23:30:00
DAY_OF_WEEK BLOCK_FROM FLAG
Monday 08:00:00 1
Monday 08:30:00 1
Monday 09:00:00 1
Monday 09:30:00 1
Monday 10:00:00 1
Monday 10:30:00 1
Monday 11:00:00 1
Monday 11:30:00 1
Tuesday 08:00:00 1
Tuesday 08:30:00 1
Tuesday 09:00:00 1
Tuesday 09:30:00 1
Tuesday 10:00:00 1
Tuesday 10:30:00 1
Tuesday 11:00:00 1
Tuesday 11:30:00 1
Wednesday 08:00:00 1
Wednesday 08:30:00 1
Wednesday 09:00:00 1
Wednesday 09:30:00 1
Wednesday 10:00:00 1
Wednesday 10:30:00 1
Wednesday 11:00:00 1
Wednesday 11:30:00 1
Thursday 08:00:00 1
Thursday 08:30:00 1
Thursday 09:00:00 1
Thursday 09:30:00 1
Thursday 10:00:00 1
Thursday 10:30:00 1
Thursday 11:00:00 1
Thursday 11:30:00 1
Friday 08:00:00 1
Friday 08:30:00 1
Friday 09:00:00 1
Friday 09:30:00 1
Friday 10:00:00 1
Friday 10:30:00 1
Friday 11:00:00 1
Friday 11:30:00 1
Monday 13:00:00 1
Monday 13:30:00 1
Monday 14:00:00 1
Monday 14:30:00 1
Monday 15:00:00 1
Monday 15:30:00 1
Monday 16:00:00 1
Monday 16:30:00 1
Tuesday 13:00:00 1
Tuesday 13:30:00 1
Tuesday 14:00:00 1
Tuesday 14:30:00 1
Tuesday 15:00:00 1
Tuesday 15:30:00 1
Tuesday 16:00:00 1
Tuesday 16:30:00 1
Thursday 13:00:00 1
Thursday 13:30:00 1
Thursday 14:00:00 1
Thursday 14:30:00 1
Thursday 15:00:00 1
Thursday 15:30:00 1
Thursday 16:00:00 1
Thursday 16:30:00 1
Friday 13:00:00 1
Friday 13:30:00 1
Friday 14:00:00 1
Friday 14:30:00 1
Friday 15:00:00 1
Wednesday 00:00:00 0
Wednesday 00:30:00 0
Wednesday 01:00:00 0
Wednesday 01:30:00 0
Wednesday 02:00:00 0
Wednesday 02:30:00 0
Wednesday 03:00:00 0
Wednesday 03:30:00 0
Wednesday 04:00:00 0
Wednesday 04:30:00 0
Wednesday 05:00:00 0
Wednesday 05:30:00 0
Wednesday 06:00:00 0
Wednesday 06:30:00 0
Wednesday 07:00:00 0
Wednesday 07:30:00 0
Wednesday 12:00:00 0
Wednesday 12:30:00 0
Wednesday 13:00:00 0
Wednesday 13:30:00 0
Wednesday 14:00:00 0
Wednesday 14:30:00 0
Wednesday 15:00:00 0
Wednesday 15:30:00 0
Wednesday 16:00:00 0
Wednesday 16:30:00 0
Wednesday 17:00:00 0
Wednesday 17:30:00 0
Wednesday 18:00:00 0
Wednesday 18:30:00 0
Wednesday 19:00:00 0
Wednesday 19:30:00 0
Wednesday 20:00:00 0
Wednesday 20:30:00 0
Wednesday 21:00:00 0
Wednesday 21:30:00 0
Wednesday 22:00:00 0
Wednesday 22:30:00 0
Wednesday 23:00:00 0
Wednesday 23:30:00 0
Tuesday 00:00:00 0
Tuesday 00:30:00 0
Tuesday 01:00:00 0
Tuesday 01:30:00 0
Tuesday 02:00:00 0
Tuesday 02:30:00 0
Tuesday 03:00:00 0
Tuesday 03:30:00 0
Tuesday 04:00:00 0
Tuesday 04:30:00 0
Tuesday 05:00:00 0
Tuesday 05:30:00 0
Tuesday 06:00:00 0
Tuesday 06:30:00 0
Tuesday 07:00:00 0
Tuesday 07:30:00 0
Tuesday 12:00:00 0
Tuesday 12:30:00 0
Tuesday 17:00:00 0
Tuesday 17:30:00 0
Tuesday 18:00:00 0
Tuesday 18:30:00 0
Tuesday 19:00:00 0
Tuesday 19:30:00 0
Tuesday 20:00:00 0
Tuesday 20:30:00 0
Tuesday 21:00:00 0
Tuesday 21:30:00 0
Tuesday 22:00:00 0
Tuesday 22:30:00 0
Tuesday 23:00:00 0
Tuesday 23:30:00 0
Monday 00:00:00 0
Monday 00:30:00 0
Monday 01:00:00 0
Monday 01:30:00 0
Monday 02:00:00 0
Monday 02:30:00 0
Monday 03:00:00 0
Monday 03:30:00 0
Monday 04:00:00 0
Monday 04:30:00 0
Monday 05:00:00 0
Monday 05:30:00 0
Monday 06:00:00 0
Monday 06:30:00 0
Monday 07:00:00 0
Monday 07:30:00 0
Monday 12:00:00 0
Monday 12:30:00 0
Monday 17:00:00 0
Monday 17:30:00 0
Monday 18:00:00 0
Monday 18:30:00 0
Monday 19:00:00 0
Monday 19:30:00 0
Monday 20:00:00 0
Monday 20:30:00 0
Monday 21:00:00 0
Monday 21:30:00 0
Monday 22:00:00 0
Monday 22:30:00 0
Monday 23:00:00 0
Monday 23:30:00 0
Saturday 00:00:00 0
Saturday 00:30:00 0
Saturday 01:00:00 0
Saturday 01:30:00 0
Saturday 02:00:00 0
Saturday 02:30:00 0
Saturday 03:00:00 0
Saturday 03:30:00 0
Saturday 04:00:00 0
Saturday 04:30:00 0
Saturday 05:00:00 0
Saturday 05:30:00 0
Saturday 06:00:00 0
Saturday 06:30:00 0
Saturday 07:00:00 0
Saturday 07:30:00 0
Saturday 08:00:00 0
Saturday 08:30:00 0
Saturday 09:00:00 0
Saturday 09:30:00 0
Saturday 10:00:00 0
Saturday 10:30:00 0
Saturday 11:00:00 0
Saturday 11:30:00 0
Saturday 12:00:00 0
Saturday 12:30:00 0
Saturday 13:00:00 0
Saturday 13:30:00 0
Saturday 14:00:00 0
Saturday 14:30:00 0
Saturday 15:00:00 0
Saturday 15:30:00 0
Saturday 16:00:00 0
Saturday 16:30:00 0
Saturday 17:00:00 0
Saturday 17:30:00 0
Saturday 18:00:00 0
Saturday 18:30:00 0
Saturday 19:00:00 0
Saturday 19:30:00 0
Saturday 20:00:00 0
Saturday 20:30:00 0
Saturday 21:00:00 0
Saturday 21:30:00 0
Saturday 22:00:00 0
Saturday 22:30:00 0
Saturday 23:00:00 0
Saturday 23:30:00 0
Thursday 00:00:00 0
Thursday 00:30:00 0
Thursday 01:00:00 0
Thursday 01:30:00 0
Thursday 02:00:00 0
Thursday 02:30:00 0
Thursday 03:00:00 0
Thursday 03:30:00 0
Thursday 04:00:00 0
Thursday 04:30:00 0
Thursday 05:00:00 0
Thursday 05:30:00 0
Thursday 06:00:00 0
Thursday 06:30:00 0
Thursday 07:00:00 0
Thursday 07:30:00 0
Thursday 12:00:00 0
Thursday 12:30:00 0
Thursday 17:00:00 0
Thursday 17:30:00 0
Thursday 18:00:00 0
Thursday 18:30:00 0
Thursday 19:00:00 0
Thursday 19:30:00 0
Thursday 20:00:00 0
Thursday 20:30:00 0
Thursday 21:00:00 0
Thursday 21:30:00 0
Thursday 22:00:00 0
Thursday 22:30:00 0
Thursday 23:00:00 0
Thursday 23:30:00 0
Sunday 00:00:00 0
Sunday 00:30:00 0
Sunday 01:00:00 0
Sunday 01:30:00 0
Sunday 02:00:00 0
Sunday 02:30:00 0
Sunday 03:00:00 0
Sunday 03:30:00 0
Sunday 04:00:00 0
Sunday 04:30:00 0
Sunday 05:00:00 0
Sunday 05:30:00 0
Sunday 06:00:00 0
Sunday 06:30:00 0
Sunday 07:00:00 0
Sunday 07:30:00 0
Sunday 08:00:00 0
Sunday 08:30:00 0
Sunday 09:00:00 0
Sunday 09:30:00 0
Sunday 10:00:00 0
Sunday 10:30:00 0
Sunday 11:00:00 0
Sunday 11:30:00 0
Sunday 12:00:00 0
Sunday 12:30:00 0
Sunday 13:00:00 0
Sunday 13:30:00 0
Sunday 14:00:00 0
Sunday 14:30:00 0
Sunday 15:00:00 0
Sunday 15:30:00 0
Sunday 16:00:00 0
Sunday 16:30:00 0
Sunday 17:00:00 0
Sunday 17:30:00 0
Sunday 18:00:00 0
Sunday 18:30:00 0
Sunday 19:00:00 0
Sunday 19:30:00 0
Sunday 20:00:00 0
Sunday 20:30:00 0
Sunday 21:00:00 0
Sunday 21:30:00 0
Sunday 22:00:00 0
Sunday 22:30:00 0
Sunday 23:00:00 0
Sunday 23:30:00 0
Friday 00:00:00 0
Friday 00:30:00 0
Friday 01:00:00 0
Friday 01:30:00 0
Friday 02:00:00 0
Friday 02:30:00 0
Friday 03:00:00 0
Friday 03:30:00 0
Friday 04:00:00 0
Friday 04:30:00 0
Friday 05:00:00 0
Friday 05:30:00 0
Friday 06:00:00 0
Friday 06:30:00 0
Friday 07:00:00 0
Friday 07:30:00 0
Friday 12:00:00 0
Friday 12:30:00 0
Friday 15:30:00 0
Friday 16:00:00 0
Friday 16:30:00 0
Friday 17:00:00 0
Friday 17:30:00 0
Friday 18:00:00 0
Friday 18:30:00 0
Friday 19:00:00 0
Friday 19:30:00 0
Friday 20:00:00 0
Friday 20:30:00 0
Friday 21:00:00 0
Friday 21:30:00 0
Friday 22:00:00 0
Friday 22:30:00 0
Friday 23:00:00 0
Friday 23:30:00 0
DAY_OF_WEEK RESULT
Friday 000000000000000011111111001111100000000000000000
Monday 000000000000000011111111001111111100000000000000
Saturday 000000000000000000000000000000000000000000000000
Sunday 000000000000000000000000000000000000000000000000
Thursday 000000000000000011111111001111111100000000000000
Tuesday 000000000000000011111111001111111100000000000000
Wednesday 000000000000000011111111000000000000000000000000