Date-conventions

[Harold]

I've always followed:

*_on => some date *_at => some datetime

I rarely ever use date only fields though. Sure you don't want to store the purchase date _and_ time? Up to you of course...