Time column

Write values into a 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 ;