How can I insert the system date into a table?

[rajeevbu]

How can I use the below query in an INSERT query?

SELECT to_char(SYSDATE , 'DD/MM/YYYY HH24:MI:SS') FROM DUAL;
#

Example:

INSERT INTO X (
1,
12,
SELECT to_char(SYSDATE , 'DD/MM/YYYY HH24:MI:SS') FROM DUAL;
)

[debasisdas]

If the target field is of date data type then you can directly user this.

INSERT INTO X (1,12,SYSDATE);