Re: [PEAR] common db question: datetime or date & time

Matthias Nothhaft wrote:
> any time I work on database schemas I wonder if it is better to use a
> datetime datatype or separate date and time fields to store timestamps.
> Does any one know a best practice or has any one some expieriences why
> what in which situation?

I prefer to use date or datetime, that are human readable.
Separation between date and time just depends on your application: most
of times it's not needed.

--
Massimiliano Arione

http://garakkio.altervista.org