PostgreSQL: How to define PARAMETER in query? [duplicate]

Question

In MSSQL, I usually use below parameter like this:

declare @StartDate as date, @EndDate as date
set @StartDate  = '08/01/2015' set @EndDate = '08/15/2015'

----------- and use it here as my Date Range of Records:

Select * from Table_Name 
where DateRange between @StartDate and @EndDate

How can I do this in PostgreSQL for generating reports/records?

Ankit Agrawal · Accepted Answer · 2015-12-22 07:25:37Z

0

Do like this After $BODY$

DECLARE startdate date;
DECLARE enddate date;

After begin

startdate ='2015-08-01';
Enddate ='2015-08-15';

retrun query 

select * from Table where daterange between startdate and endate

answered Dec 22, 2015 at 7:25

Ankit Agrawal

2,4541 gold badge17 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

fLen Over a year ago

result: ERROR: syntax error at or near "date" LINE 3: DECLARE startdate date; ^ ********** Error **********

Ankit Agrawal Over a year ago

@fLen its throwing error because you are executing this syntax directly.....use this syntax in your function then it will work fine.

Collectives™ on Stack Overflow

PostgreSQL: How to define PARAMETER in query? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related