ERROR: column “sysdate” does not exist Postgresql

263 viewsPostgreSQLPostgreSQL Postgressql
0
0 Comments

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

1 Answer

0
Manohar581 0 Comments

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
Write your answer.