Skip to content

Instantly share code, notes, and snippets.

@webmayak

webmayak/randomize-date.sql

Last active February 25, 2019 04:49
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save webmayak/f07f453d0c5101a930344116dc5b4e54 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save webmayak/f07f453d0c5101a930344116dc5b4e54 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. webmayak revised this gist Feb 25, 2019. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions randomize-date.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,5 @@
    UPDATE `shop_product_reply` SET created = FROM_UNIXTIME(UNIX_TIMESTAMP('2018-09-10 14:53:27') + FLOOR(0 + (RAND() * 86400 * 30 * 5)))

    -- '2018-09-10 14:53:27' - дата старта рандомизации
    -- 30 - кол-во дней в месяце
    -- 5 - кол-во месяцев диапазона рандомизации
  2. webmayak created this gist Feb 25, 2019.
    4 changes: 4 additions & 0 deletions randomize-date.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,4 @@
    UPDATE `shop_product_reply` SET created = FROM_UNIXTIME(UNIX_TIMESTAMP('2018-09-10 14:53:27') + FLOOR(0 + (RAND() * 86400 * 30 * 5)))

    -- 30 - кол-во дней в месяце
    -- 5 - кол-во месяцев диапазона рандомизации