Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF';
create table types
(
    id          number                                                                                               not null,
    description varchar(255)                                                                                         not null,
    created_at  timestamp                                                                                            null,
    updated_at  timestamp                                                                                            null,
    deleted_at  timestamp                                                                                            null,
    CONSTRAINT autenticacion_id   PRIMARY KEY (id)
); 
insert into types (id, description) values (1, 'hello world', (select sysdate from dual))
ORA-00913: too many values

INSERT INTO types (id, description, created_at)
VALUES (1, 'hello world', SYSTIMESTAMP);
1 rows affected

INSERT INTO types (id, description, created_at)
VALUES (2, 'hello world', SYSTIMESTAMP AT TIME ZONE 'UTC')
1 rows affected

SELECT * FROM types;


ID
DESCRIPTION
CREATED_AT
UPDATED_AT
DELETED_AT


1
hello world
2022-12-23 21:33:20.029689
null
null

2
hello world
2022-12-23 21:33:20.041892
null
null

ID	DESCRIPTION	CREATED_AT	UPDATED_AT	DELETED_AT
1	hello world	2022-12-23 21:33:20.029689	null	null
2	hello world	2022-12-23 21:33:20.041892	null	null