That sounds good. I am planning on having a calandar function, so datetime will be preferred so I can sort easier.Quote:
It is also faster to sort query output by a datetime datatype than it is to sort it by a varchar datatype.
Printable View
That sounds good. I am planning on having a calandar function, so datetime will be preferred so I can sort easier.Quote:
It is also faster to sort query output by a datetime datatype than it is to sort it by a varchar datatype.
Quote:
Originally posted here by chsh
It is also faster to sort query output by a datetime datatype than it is to sort it by a varchar datatype.
This is why I said that if the date were only to be used as a display output for posts, not for sorting purposes.
For sorting purposes you would be much better off using the DATETIME formatting.
xmaddness
Planet Maddness Industries
http://www.planetmaddness.com