Gorakshnath

Below Python program can be used to fetch count from PG database , for given duration.  import psycopg2 as pg import pandas as pd import pandas.io.sql as psql def get_data_MSC(dbname,test_starttime,test_endtime,timezone_tenant):                                          timezone =timezone_tenant                     Created_Column_Append =" where ((to_timestamp(created_date) AT TIME ZONE '"+timezone+"' ) >= '"+test_starttime+"' ) and ((to_timestamp(created_date) AT TIME ZONE '"+timezone+"' ) <= '"+test_endtime+"' )"                     connection = pg.connect(host=" XXX.xx.XX.XXX ",database=dbname, user="postgres", password="XXXX")                     Tenant_VendorData    = pd.read_sql('select count(*) ...