[SQL] DATEADD

[Sumita Biswas]

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])