insert into table_name (date_field)
values (to_char(sysdate, 'yyyy/mm/dd hh24:mi:ss'));
values (to_char(sysdate, 'yyyy/mm/dd hh24:mi:ss'));
👍1
insert into table_name
(date_field)
values
(to_date(sysdate, 'yyyy/mm/dd hh24:mi:ss'));
The value is inserted as 08-02-12 12:00:00. In this query, it always stores the default time as 12 a.m.
(date_field)
values
(to_date(sysdate, 'yyyy/mm/dd hh24:mi:ss'));
The value is inserted as 08-02-12 12:00:00. In this query, it always stores the default time as 12 a.m.