{"id":1712958,"user_name":null,"score":2,"text":"Pisane z \"palca\" bez test\u00f3w to mog\u0105 by\u0107 b\u0142\u0119dy. Jeszcze jest pytanie, jak masz trzymane daty i czas czy w odpowiednich typach, czy w ci\u0105gach znakowych. \n```sql\nselect data, max(godzina), min(gdzina), sum( case substr(numer_paczki,0,1) = '0' then 1 else 0)\nas paczki_z_0 , sum( case substr(numer_paczki,0,1) = '1' then 1 else 0)\nas paczki_z_1 .....  sum( case substr(numer_paczki,0,1) = '9' then 1 else 0)\nas paczki_z_9 , numer_magazynu from paczki group by numer_magazynu, data,  substr(godzina,0,2)\n```","edit_count":3,"is_voted":null,"is_accepted":null,"is_subscribed":null,"user_id":99030,"deleter_name":null,"delete_reason":null,"orderingScore":2,"created_at":"2020-10-08T09:44:00+02:00","updated_at":"2020-10-08T10:21:55+02:00","deleted_at":null,"user":{"id":99030,"name":"UglyMan","is_online":false,"allow_sig":1,"allow_count":1,"allow_smilies":0,"posts":2206,"visited_at":"2022-01-17T10:22:57.000000Z","created_at":"2019-03-04T13:37:58.000000Z","initials":"UM","is_verified":false,"is_deleted":true,"is_incognito":false,"is_blocked":false,"is_blocked_perm":false,"deleted_at":"2022-01-17T10:22:57.000000Z","photo":"\/uploads\/photo\/Vsi8eCkDzVL3yX1nVOEGMOkVww5zYzrWcdwaiTkz.jpeg"},"html":"<p>Pisane z \"palca\" bez test\u00f3w to mog\u0105 by\u0107 b\u0142\u0119dy. Jeszcze jest pytanie, jak masz trzymane daty i czas czy w odpowiednich typach, czy w ci\u0105gach znakowych.<\/p>\n<div class=\"markdown-code\"><div class=\"copy-button\">Kopiuj<\/div><pre><code class=\"language-sql line-numbers\">select data, max(godzina), min(gdzina), sum( case substr(numer_paczki,0,1) = '0' then 1 else 0)\nas paczki_z_0 , sum( case substr(numer_paczki,0,1) = '1' then 1 else 0)\nas paczki_z_1 .....  sum( case substr(numer_paczki,0,1) = '9' then 1 else 0)\nas paczki_z_9 , numer_magazynu from paczki group by numer_magazynu, data,  substr(godzina,0,2)\n<\/code><\/pre><\/div>\n","url":"http:\/\/static.175.128.202.116.clients.your-server.de\/Forum\/Bazy_danych\/344674-sqlite_zliczanie_ilosci_rekordow_w_przedzialach_dniowych_i_godzinowych?p=1712958#id1712958","is_locked":false,"editor":{"id":90224,"name":"cerrato","is_online":false,"bio":"Pami\u0119taj - je\u015bli nigdy nie uwierzysz w siebie, to nigdy si\u0119 nie zawiedziesz","location":"Pozna\u0144","allow_sig":1,"allow_count":1,"allow_smilies":1,"posts":9216,"visited_at":"2026-07-14T12:04:38.000000Z","created_at":"2018-02-11T21:11:51.000000Z","group_name":"Moderator Kariera","initials":"CE","is_verified":false,"is_deleted":false,"is_incognito":false,"is_blocked":false,"is_blocked_perm":false,"deleted_at":null,"photo":"\/uploads\/photo\/5a\/5a8ecfd189a33.jpg","sig":"<br \/><strong>NACZELNY FORUMOWY HEJTER APPLE<\/strong><br \/><br \/>\nThat game of life is hard to play, I'm gonna lose it anyway<br \/>\nThe losing card I'll someday lay, So this is all I have to say<br \/>\n<br \/><br \/>\n<a href=\"https:\/\/www.youtube.com\/watch?v=KCnUCIOkJgE\" rel=\"nofollow\" target=\"_blank\">https:\/\/www.youtube.com\/watch?v=KCnUCIOkJgE<\/a>\n"},"permissions":{"write":false,"delete":false,"update":false,"accept":false},"moderatorPermissions":{"delete":false,"update":false,"accept":false,"merge":false,"sticky":false,"admAccess":false},"comments":[],"comments_count":0,"assets":[],"metadata":"eyJpdiI6InY4ejNWbGc5eGk5bXZTalkwM1Vlbnc9PSIsInZhbHVlIjoibjRVcm5JdVIva00xRk1ndTlIb041Y1hWZGpmK0FBT0lMVzU5MVJFcmtnSnBiTGp6K2FzYTgvRmU4Vmt0WFJzRE1EYnQvV21pTVFUL3RWQSs1cGtNNnE1dlBwMGhabDVJTWdncWdnLzlnenNtWkoxMS9scWxRUUlVKy9leUYyZGsiLCJtYWMiOiI3ZDc5MGEyYzdiZWJlY2Y2OTAyMmUzMGZlYjFiOWU2MTUwZWY5ZGJlMzA1ZmViNTAyNWI5YjA2MGNjOGRlNDliIiwidGFnIjoiIn0=","has_review":false,"review_style":"info","parentPostId":null,"childrenFolded":false,"type":"regular","highlighted":false}