Skip to content

Instantly share code, notes, and snippets.

@kakha13

kakha13/Select Older than 1 day rows

Last active December 28, 2015 23:19
Show Gist options

  • Select an option

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

Select an option

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

Revisions

  1. kakha13 revised this gist Nov 21, 2013. 1 changed file with 7 additions and 8 deletions.
    15 changes: 7 additions & 8 deletions Select Older than 1 day rows
    View file
    Original file line number Diff line number Diff line change
    @@ -2,11 +2,10 @@
    -- Select Older than 1 day rows

    SELECT
    *
    FROM
    column_name
    WHERE
    user='1234'
    AND
    added_time < DATE_ADD(NOW(), INTERVAL - 1 DAY)
    AND added_time <> '0000-00-00 00:00:00'
    *
    FROM
    column_name
    WHERE
    USER = '1234'
    AND added_time < DATE_ADD(NOW(), INTERVAL - 1 DAY)
    AND added_time <> '0000-00-00 00:00:00'
  2. kakha13 created this gist Nov 21, 2013.
    12 changes: 12 additions & 0 deletions Select Older than 1 day rows
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,12 @@
    -- BY Kakha Giorgashvili
    -- Select Older than 1 day rows

    SELECT
    *
    FROM
    column_name
    WHERE
    user='1234'
    AND
    added_time < DATE_ADD(NOW(), INTERVAL - 1 DAY)
    AND added_time <> '0000-00-00 00:00:00'