ERROR: column “sysdate” does not exist Postgresql

672 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

The error message “column ‘sysdate’ does not exist” in PostgreSQL typically occurs when you try to reference a column that doesn’t exist in the table. In PostgreSQL, there is no built-in column named ‘sysdate’.

If you intended to use the current date and time in your query, you can use the CURRENT_DATE or CURRENT_TIMESTAMP functions. Here’s an example:

SELECT CURRENT_DATE; -- Retrieves the current date
SELECT CURRENT_TIMESTAMP; -- Retrieves the current date and time

If you were trying to insert the current date into a table, you can use the CURRENT_DATE function as a value for the corresponding column. Here’s an example:

INSERT INTO your_table (date_column) VALUES (CURRENT_DATE);

Make sure to replace ‘your_table’ with the actual name of your table, and ‘date_column’ with the appropriate column name where you want to store the current date.

Manohar Changed status to publish June 6, 2023
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
Write your answer.