ERROR: column “sysdate” does not exist Postgresql

720 viewsPostgreSQLPostgreSQL Postgressql
0

What does PostgreSQL’s equivalent of Oracle’s SYSDATE function do?

ERROR: column “sysdate” does not exist

 

 

Manohar Changed status to publish August 25, 2022
Add a Comment
0

sysdate is not supported by PostgreSQL, Please use the function below that is in place of that.

 

Solution :  SYSDATE  function should be changed to clock_timestamp() 

 

 

 

Manohar Changed status to publish August 25, 2022
Add a Comment
You are viewing 1 out of 2 answers, click here to view all answers.
Write your answer.