Error :
There seems to be a syntax error near "(".
Here is the SQL statement causing the issue:
CREATE TABLE IF NOT EXISTS tickets (
numero INTEGER PRIMARY KEY AUTOINCREMENT,
identifier VARCHAR(4) NOT NULL,
subject VARCHAR(150) NOT NULL,
concerned_staff TEXT NULL,
author_id VARCHAR(22) NOT NULL,
created_at TIMESTAMP NOT NULL DEFAULT current_timestamp(),
is_archived BOOLEAN NOT NULL DEFAULT false,
ticket_channel_id VARCHAR(24) NOT NULL
);
I am puzzled as to why this error is occurring. The only other question I found here does not address my specific situation. My aim is to retrieve a numerical representation of time. Instead of having 21-12-2022 10:00:00, I want to receive 1671613200.