Best format to save date?

[eluser]Jondolar[/eluser]
[quote author="xwero" date="1241672878"]The functions can be database specific but if you work with a database abstraction library these functions can be handled by the library. Otherwise you only need to regex the files with sql statements. Changing a database for another is not a decision you make overnight.[/quote]

Okay, except none of the posts above talk about any type of data abstraction library that has date/time functions and I didn't see anything in CI.

Also, if you are distributing your script, you might want to support multiple databases and, therefore, you would need to have this functionality as part of the distributed script which means you either use a data type that is portable and use PHP for manipulating the data or you use a yet-to-be-defined abstraction layer and make all your date/time manipulation calls to this abstraction layer.