> On 09/06/2023 07:51 CEST Rama Krishnan wrote:
>
> CREATE or REPLACE PROCEDURE deleted_cards_count_test(start_date TIMESTAMP,
> end_date TIMESTAMP) AS $$
> DECLARE
> current_date TIMESTAMP;
> month_start_date TIMESTAMP;
> month_end_date TIMESTAMP;
> month24_end_date TIMESTAMP;
> no_deleted_cards
On 6/9/23 00:51, Rama Krishnan wrote:
Hi All,
I have a table like below
Create table if not exists digi_card(
Digi_card_id varchar(100),
created_date timestamp,
updated_date timestamp,
status varchar(50),
reason varchar(50)
);
Sample values:
Insert into digi_card value
Hi All,
I have a table like below
Create table if not exists digi_card(
Digi_card_id varchar(100),
created_date timestamp,
updated_date timestamp,
status varchar(50),
reason varchar(50)
);
Sample values:
Insert into digi_card values ('ee4422', '2019-03-01 00:25:00', '202