What does PostgreSQL’s equivalent of Oracle’s SYSDATE function do?
ERROR: column “sysdate” does not exist
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.
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()