Skip to content

Instantly share code, notes, and snippets.

@ajl100b

ajl100b/random time add

Created January 9, 2018 12:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ajl100b/46cd5fb10674e68093208a69c80d3695 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ajl100b/46cd5fb10674e68093208a69c80d3695 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
random time add
UPDATE oobeo_api_activity AS a1
SET time_end = (a2.time_end + (random() * (timestamp '2014-01-10 11:00:00' -
timestamp '2014-01-10 10:00:00')))
FROM oobeo_api_activity AS a2
WHERE a1.activity_type_id = 6 AND a2.activity_type_id=2 AND a1.visit_id = a2.visit_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment