postgresqlHow can I set a PostgreSQL interval to zero?
To set a PostgreSQL interval to zero, you can use the interval '0'
syntax. Here is an example of setting an interval column to zero:
UPDATE mytable
SET myinterval = interval '0'
WHERE id = 1
The output of the above command will be the number of rows affected.
Code explanation
UPDATE mytable
- This is the command to update a table.SET myinterval = interval '0'
- This is the command to set a PostgreSQL interval to zero.WHERE id = 1
- This is the command to specify the row to update.
Helpful links
More of Postgresql
- How do I parse XML data using PostgreSQL?
- How can Zalando use PostgreSQL to improve its software development?
- How can I use PostgreSQL XOR to compare two values?
- How do I use PostgreSQL ZonedDateTime to store date and time information?
- How can I use PostgreSQL's "zero if null" feature?
- How can I use PostgreSQL with YAML?
- How do I use PostgreSQL's XMLTABLE to parse XML data?
- How do I use the PostgreSQL XML type?
- How can I convert XML data to a PostgreSQL table?
- How do I set the PostgreSQL work_mem parameter?
See more codes...