Time column

Write values into a time column.

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 subseconds; when excluded it’s set to zero (0). For example, one o’clock in the afternoon:

13:00:00.000
13:00:00

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 ;

Time column

Prerequisites

String format

Was this helpful?

Give Feedback