Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Database Design

  1. October 29th, 2004, 02:15 AM #11
    Soda_Popinsky
    Soda_Popinsky is offline
    Join Date
    Nov 2003
    Posts
    1,426
    It is also faster to sort query output by a datetime datatype than it is to sort it by a varchar datatype.
    That sounds good. I am planning on having a calandar function, so datetime will be preferred so I can sort easier.
    Reply With Quote Reply With Quote
  2. October 29th, 2004, 08:32 PM #12
    xmaddness
    xmaddness is offline
    Webius Designerous Indiginous
    Join Date
    Mar 2002
    Location
    South Florida
    Posts
    1,123
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules