Best format to save date?

[eluser]n0xie[/eluser]
I agree with xwero. All those database abstractions are a bit too much imho. They make it easier 'if you ever change database type', but how many times does that actually happen? Migrating database platform is an huge decision which won't happen 95% of the time.

Meanwhile I like my MySQL specific datetime functions so I say, why bother with timestamps and all the converting it brings with it, when there are options available specifically designed for datetime manipulation?