Time column

Write values into a time column.

Tip: Commands in this section, use the Cycling keyspace and cyclist_races table.

String format

time

time string format:

HH:MM:SS[.fff]

where

HH: two digit hour using a 24-hour clock.
MM: two digit minute.
SS: two digit seconds.
(Optional) .fff: up to three digit sub-seconds; 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 ;