to_char((CURRENT_DATE)::timestamp with time zone, 'yyyy'::text)
to_char((CURRENT_DATE)::timestamp with time zone, 'yyyy-MM-dd'::text)
to_char((CURRENT_DATE)::timestamp with time zone, 'yyyy-MM-dd hh24:MI:ss'::text)
to_char((CURRENT_DATE)::timestamp with time zone, 'yyyy-MM-dd hh:MM:ss'::text)
The image below shows the effect
Read More:
- In SQLite database, set the default value for the field as the current time
- Set the default time to the current value in MySQL
- Idea2021 reports an error. Default operand size is 64 sets the startup task to automatically add the registry
- [BUG-mybatis-plus] org.postgresql.util.PSQLException: ERROR: syntax error at or near “current_date“
- @Value sets the default value
- IntelliJ idea sets the default working directory
- Get the default value of the field
- Error: field * doesn’t have a default value
- Mybatis error “field ‘ID’ doesn’t have a default value”
- Error 1364 (HY000): field ‘SSL_ cipher’ doesn’t have a default value
- Pyspark36830;- 25509;- Postgresql38169; java.lang.ClassNotFoundException: org.postgresql.Driver
- Linux view current date and time
- Common shell (1): shell gets the current time stamp of the system
- How to get the current time in java time string
- The shell gets the current time of the system and formats it
- Use xx [‘xx ‘] = XX to set field value or does not support field: XXX
- Shell gets the current time of the system and formats it
- MySQL：ERROR 1067 (42000): Invalid default value for ‘end_time’
- Keyerror: “year not in index”
- PHP connection PostgreSQL error call to undefined function PG_ connect()