postgresqlHow do I use PostgreSQL ZonedDateTime to store date and time information?
PostgreSQL's ZonedDateTime
type is a convenient way to store date and time information. It is a combination of a LocalDateTime
and a ZoneId
that specifies the timezone associated with the date and time.
For example, to store the date and time for the current moment in the UTC timezone, you can use the following code:
import java.time.ZonedDateTime;
ZonedDateTime nowUtc = ZonedDateTime.now(ZoneId.of("UTC"));
System.out.println(nowUtc);
This will output something like 2020-04-27T22:30:05.142345Z[UTC]
.
You can also use ZonedDateTime
to create a LocalDateTime
object in a specific timezone, or to convert an existing LocalDateTime
object to a different timezone. For example:
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.time.ZonedDateTime;
LocalDateTime now = LocalDateTime.now();
ZonedDateTime nowUtc = ZonedDateTime.of(now, ZoneId.of("UTC"));
System.out.println(nowUtc);
This will output something like 2020-04-27T22:30:05.142345Z[UTC]
.
To store a ZonedDateTime
in a PostgreSQL database, you can use the timestamptz
data type. For example:
INSERT INTO my_table (created_at) VALUES (timestamptz '2020-04-27T22:30:05.142345Z[UTC]');
Helpful links
More of Postgresql
- How can I troubleshoot zero damaged pages in PostgreSQL?
- How do I use PostgreSQL with Qt?
- How can I monitor PostgreSQL performance using Zabbix?
- How can I set a PostgreSQL interval to zero?
- How can I use PostgreSQL with YAML?
- How can I retrieve data from PostgreSQL for yesterday's date?
- How can I extract the year from a date in PostgreSQL?
- How can Zalando use PostgreSQL to improve its software development?
- How do I use PostgreSQL's XMIN and XMAX features?
- How do I use PostgreSQL's XMLTABLE to parse XML data?
See more codes...