Date column

Write values using the current day/time or a string format into a date column.

Write values using the current day/time or a string format into a date column.
Tip: Commands in this section use the Setting up the Cycling keyspace and cyclist_alt_stats table and data.

String format

date
date string format:
yyyy-mm-dd
Where the elements of a date are separated with a hyphen:
  • yyyy: four-digit year
  • mm: two-digit month
  • dd: two-digit day
For example, May 5, 2017:
2017-05-05

Getting the current day

Use toDate(now()) to insert the current day into a date field.

Procedure

  • To INSERT dates:
    • Current date (today) for last_race values.
      INSERT INTO cycling.cyclist_alt_stats (
        id,
        last_race
      ) VALUES (
        ed584e99-80f7-4b13-9a90-9dc5571e6821,
        todate(now())
      );
    • String format (yyyy-mm-dd) for first_race value.
      INSERT INTO cycling.cyclist_alt_stats (
        id,
        first_race
      ) VALUES (
        ed584e99-80f7-4b13-9a90-9dc5571e6821,
        '2006-03-15'
      );
  • To UPDATE a date field:
    • Current date (today) for last_race.
      UPDATE cycling.cyclist_alt_stats
      SET last_race = toDate(now())
      WHERE id = ed584e99-80f7-4b13-9a90-9dc5571e6821;
    • Use formatted string (yyyy-mm-dd) for birthday.
      UPDATE cycling.cyclist_alt_stats
      SET birthday = '1987-03-07'
      WHERE id = ed584e99-80f7-4b13-9a90-9dc5571e6821;
    Select the date columns from the table.
    SELECT first_race, last_race, birthday
    FROM cycling.cyclist_alt_stats
    WHERE id = ed584e99-80f7-4b13-9a90-9dc5571e6821;
     first_race | last_race  | birthday
    ------------+------------+------------
     2006-03-15 | 2017-04-16 | 1989-07-05
    
    (1 rows)