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