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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Massimiliano Arione

2006-06-27, 8:00 am

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

Sponsored Links