How to insert current datetime in postgresql insert query [duplicate]

timestamp (or date or time columns) do NOT have "a format".

Any formatting you see is applied by the SQL client you are using.

To insert the current time use current_timestamp as documented in the manual:

INSERT into "Group" (name,createddate) VALUES ('Test', current_timestamp);

To display that value in a different format change the configuration of your SQL client or format the value when SELECTing the data:

select name, to_char(createddate, ''yyyymmdd hh:mi:ss tt') as created_datefrom "Group"

For psql (the default command line client) you can configure the display format through the configuration parameter DateStyle: https://www.postgresql.org/docs/current/static/runtime-config-client.html#GUC-DATESTYLE

postgresql datetime insert

For current datetime, you can use now() function in postgresql insert query.

You can also refer following link.

postgresql datetime insert

You can of course format the result of current_timestamp().Please have a look at the various formatting functions in the official documentation.

CodeHunter