I logon to my credit card account this morning to make a payment and find 1300 quid of transactions I never made. £690 were unposted transactions, so I caught it on time. It's all been sorted out now, but still it's frustrating.

I had made an Internet purchase two days before the activity started, I'll not name and shame the company because I'm not sure it was them. It's a company I would not normally have trusted with my card, but it was a present and I needed to buy it.
I think it's interesting to see the tester amounts posted to oxfam before the bigger transactions. I think it's about time I started thinking a little more about security.

Posted by jaffs at 01:32 PM | Permalink | Comments (1)

I should not admit how I was investigating doing this, until Marc kindly pointed out the datediff function in MySQL as outlined on this page.
To get the number of days between two dates, be it before or after.
mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
-> 1

or between a given date and today

mysql> SELECT DATEDIFF('1999-12-31 00:00:00',CURRENT_DATE())
-> -2442
The Date functions docs should have been investigated before now.

Posted by jaffs at 04:36 PM | Permalink