Skip to content

Instantly share code, notes, and snippets.

@GreatPotato

GreatPotato/gist:987d389b2f2d18a7361b

Created February 4, 2015 15:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save GreatPotato/987d389b2f2d18a7361b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save GreatPotato/987d389b2f2d18a7361b to your computer and use it in GitHub Desktop.
Download ZIP
Get incorrect timezone payments from PayPal
Raw
gistfile1.sql
SELECT DateTime, `Time Zone`, Name, Currency, Gross, `Transaction ID`, Type
FROM transactions
WHERE TIME(DateTime) BETWEEN '00:00:00' AND '00:59:59'
AND (Type = 'Website Payments Pro API Solution' OR Type = 'Shopping Cart Payment Received')
AND `Time Zone` = 'BST'
AND DateTime > '2014-09-22 00:00:00'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment