Time column
Write values into a time column.
String format
- time
- time string
format:
whereHH:MM:SS[.fff]
- HH: two-digit hour using a 24 hour clock.
- MM: two-digit minute.
- SS: two-digit seconds.
- (Optional) .fff: up to three-digit subseconds; when excluded it's set to zero (0).
For example, one o'clock in the afternoon:13:00:00.000 13:00:00
Procedure
-
To INSERT time:
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 ;