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

Justin Patrin

2006-06-27, 7:00 pm

On 6/27/06, Matthias Nothhaft <php@mahono.com> wrote:
> Hi folks,
>
> 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?
>

If you're using date and time together as one then I would see no
reason to separate them into 2 fields. I use datetime fairly often
myself.

> Thanks in advance for any help!
>
> Regards,
> Matthias
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
Justin Patrin

Sponsored Links