SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE ride (id int, inserted_at timestamp) ; select * from ride limit 10; INSERT INTO ride (id, inserted_at) VALUES ('106904416', '2022-04-01 10:41:52'), ('106967748', '2022-04-02 08:54:05'), ('107031080', '2022-04-03 11:18:06'), ('107094412', '2022-04-04 11:43:09'), ('107157744', '2022-04-05 09:22:47'), ('107221076', '2022-04-06 07:56:15'), ('107284408', '2022-04-07 06:53:08'), ('107347740', '2022-04-08 06:11:36'), ('107411072', '2022-04-09 07:38:48'), ('107474404', '2022-04-10 11:38:51'), ('107537736', '2022-04-11 12:39:17'), ('107601068', '2022-04-12 10:55:30'), ('107664400', '2022-04-13 10:06:02'), ('107727732', '2022-04-14 09:00:14'), ('107791064', '2022-04-15 08:17:34'), ('107854396', '2022-04-16 11:55:17'), ('107917728', '2022-04-18 06:01:51'), ('107981060', '2022-04-19 09:48:43'), ('108044392', '2022-04-20 08:04:41'), ('108107724', '2022-04-21 07:01:09'), ('108171056', '2022-04-22 05:56:45'), ('108234388', '2022-04-22 19:49:24'), ('108361052', '2022-04-25 12:50:31'), ('108424384', '2022-04-26 11:18:36'), ('108487716', '2022-04-27 09:58:27'), ('108551048', '2022-04-28 08:23:17'), ('108614380', '2022-04-29 07:06:28'), ('108741044', '2022-04-30 18:34:05'), ('108677712', '2022-04-29 19:14:37'), ('108804376', '2022-05-02 11:29:44'), ('108867708', '2022-05-03 11:56:30'), ('108931040', '2022-05-04 10:25:39'), ('108994372', '2022-05-05 09:01:00'), ('109057704', '2022-05-06 06:37:13'), ('109121036', '2022-05-06 20:34:59'), ('109184368', '2022-05-07 19:06:18'), ('109247700', '2022-05-09 07:18:11'), ('109311032', '2022-05-09 20:07:29'), ('109437696', '2022-05-11 14:58:29'), ('108297720', '2022-04-24 08:14:02'), ('109374364', '2022-05-10 16:03:18'), ('109501028', '2022-05-12 13:33:06'), ('109564360', '2022-05-13 11:46:35'), ('109627692', '2022-05-14 10:13:30'), ('109691024', '2022-05-15 13:15:08'), ('109754356', '2022-05-16 13:16:46'), ('109817688', '2022-05-17 10:03:24'), ('109881020', '2022-05-18 08:07:46'), ('109944352', '2022-05-19 06:22:52'), ('110071016', '2022-05-20 16:34:53'), ('110007684', '2022-05-19 20:20:36'), ('110134348', '2022-05-21 17:26:42'), ('110197680', '2022-05-23 07:23:54'), ('110261012', '2022-05-24 05:05:00'), ('110324344', '2022-05-24 18:09:48'), ('110387676', '2022-05-25 16:16:13'), ('110451008', '2022-05-26 14:36:59'), ('110514340', '2022-05-27 12:28:23'), ('110577672', '2022-05-28 10:43:49'), ('110641004', '2022-05-29 13:09:27'), ('110704336', '2022-05-30 13:09:02'), ('110831000', '2022-06-01 08:50:45'), ('110767668', '2022-05-31 10:28:19'), ('110894332', '2022-06-02 08:18:32'), ('110957664', '2022-06-03 07:20:19'), ('111020996', '2022-06-04 09:19:58'), ('111084328', '2022-06-05 13:34:52'), ('111147660', '2022-06-06 13:37:34'), ('111210992', '2022-06-07 12:07:38'), ('111274324', '2022-06-08 11:18:56'), ('111337656', '2022-06-09 11:57:29'), ('111400988', '2022-06-10 12:11:05'), ('111464320', '2022-06-11 11:51:47'), ('111527652', '2022-06-12 16:51:59'), ('111590984', '2022-06-13 16:02:37'), ('111654316', '2022-06-14 15:58:55'), ('111717648', '2022-06-15 15:47:47'), ('111780980', '2022-06-16 15:50:48'), ('111844312', '2022-06-17 15:21:06'), ('111907644', '2022-06-18 16:26:36'), ('111970976', '2022-06-20 07:31:05'), ('112034308', '2022-06-21 07:01:06'), ('112097640', '2022-06-22 07:05:01'), ('112160972', '2022-06-23 07:21:53'), ('112224304', '2022-06-24 06:50:02'), ('112287636', '2022-06-25 05:41:55'), ('112350968', '2022-06-26 08:48:44'), ('112414300', '2022-06-27 11:28:42'), ('112477632', '2022-06-28 10:32:12'), ('112540964', '2022-06-29 10:40:48'), ('112604296', '2022-06-30 09:54:20') ; select * from ride CREATE OR REPLACE FUNCTION count_btween_timestamps(tbl text, start_ts TIMESTAMP WITHOUT TIME ZONE, end_ts TIMESTAMP WITHOUT TIME ZONE) RETURNS int AS $$ declare count int; begin EXECUTE format('SELECT count(*) FROM %1$s WHERE inserted_at > ''%2$s'' ::timestamp and inserted_at < ''%3$s'' ::timestamp', tbl,start_ts, end_ts) INTO count; RETURN count; end; $$ LANGUAGE PLPGSQL; SELECT prosrc FROM pg_proc WHERE proname = 'count_btween_timestamps'; select * FROM count_btween_timestamps('ride'::text, '2022-04-01'::timestamp, '2022-05-01'::timestamp);
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear