Guest User

Untitled

a guest
Jan 15th, 2019
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. /*
  2. socialcliro@production/social> select * from schedule_entry where id = 1221;
  3. +------+----------------+---------------------+---------------------+------------------------+------------+---------------+
  4. | id | competition_id | creation_date | game_start_date | game_start_day_of_week | game_label | contest_label |
  5. +------+----------------+---------------------+---------------------+------------------------+------------+---------------+
  6. | 1221 | 68 | 2019-01-15 09:00:00 | 2019-01-18 21:00:00 | 6 | NULL | NULL |
  7. +------+----------------+---------------------+---------------------+------------------------+------------+---------------+
  8. 1 row in set (0.00 sec)
  9. */
  10. begin;
  11. update schedule_entry set creation_date = date_add(creation_date, interval 1 day) where id = 1221;
  12.  
  13. commit;
Add Comment
Please, Sign In to add comment