Results 1 to 3 of 3

Thread: sql sorting

  1. May 15th, 2008, 10:39 PM #1
    wence
    wence is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2006
    Posts
    274

    sql sorting

    'if datetime in mysql database is saved in the format of yyyyMMdd, is it possible to sort the date string of yyyyMMdd in ascending or descending order?
    Reply With Quote Reply With Quote
  2. May 16th, 2008, 11:31 AM #2
    axion_sa
    axion_sa is offline
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724

    Re: sql sorting

    Yes. But why store it as a string when a type is available for date and time?
    Build solutions from Windows Explorer
    Reply With Quote Reply With Quote
  3. May 16th, 2008, 02:49 PM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: sql sorting

    Datetime data type - http://www.sqlmag.com/Articles/Artic...3488.html?Ad=1
    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


Click Here to Expand Forum to Full Width