14.2.2 Using Datetime Data Types
This section explains in detail working of datetime data types such as date, time and timestamp.
Overview of Datetime Data Types in Graph Server (PGX)
Table 14-3 presents the overview of the five datetime data types supported by PGX along with example values.
Note:
PGX also supports custom format specification when loading data into PGX.Table 14-3 Overview of Datetime Data Types in PGX
| Data Type | Loading and Storing | PGX Java API | PGQL and Filter Expression | Example Value-1 | Example Value-1 |
|---|---|---|---|---|---|
date |
local_date |
LocalDate |
DATE |
2001-01-29 |
2018-10-08 |
time |
time |
LocalTime |
TIME |
10:15 |
10:30:01.000 |
timestamp |
timestamp |
LocalDateTime |
TIMESTAMP |
2001-01-29 10:15 |
2018-10-08 10:30:01.000 |
time with time zone |
time_with_timezone |
OffsetTime |
TIME WITH TIME ZONE |
10:15+01:00 |
10:30:01.000-08:00 |
timestamp with time zone |
timestamp_with_timezone |
OffsetDateTime |
TIMESTAMP WITH TIME ZONE |
2001-01-29 10:15+01:00 |
2018-10-08 10:30:01.000-08:00 |