I had the following code in my MSSQL Stored Procedure:
--Adding 23Hrs 59Mins 59Secs to the ToDate(@ld_ToDate is
DateTime datatype)
SET @ld_ToDate = DATEADD(ss, 86399, @ld_ToDate);
I have changed it to the following for Postgres Function:
--Adding 23Hrs 59Mins 59Secs to the ToDate
--Here $2 is an input variable(timestamp datatype)
lv_ToDate := $2 + interval ''86399 seconds'';
Does this make sense?
Any pointers appreciated.
Thanks,
Sumita