Time column
Write values into a time column.
String format
- time
-
time string format:
<HH>:<MM>:<SS>[.<fffffffff>]
where
-
HH: two-digit hour using a 24 hour clock.
-
MM: two-digit minute.
-
SS: two-digit seconds.
-
(Optional) fffffffff: up to nine-digit nanoseconds, when excluded it’s set to zero (0).
-
For example, 2:30 PM:
14:30:00 14:30:00.000 14:30:00.000000000
-
To insert data into a time column:
INSERT INTO cycling.cyclist_races (
id,
races
) VALUES (
5b6962dd-3f90-4c93-8f61-eabfa4a803e2,
[ { race_time : '07:00:00'},
{ race_time : '08:00:00' } ]
);-
To UPDATE a time field:
UPDATE cycling.cyclist_races SET races[1] = { race_time : '06:00:00'}
WHERE id = 5b6962dd-3f90-4c93-8f61-eabfa4a803e2 ;