1. No Profile Picture
    Devshed Newbie (0 - 499 posts)

    i have a table with Timestamp(14) ...
    i want to select records from latest Date and Time ...
    How can i do this?

  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    Are you saying you want the most recent record?

    select * from tablename order by datefield limit 1;

Similar Threads

  1. casesensitive sorting in - apply templates
    By nihaarika2002 in forum XML Programming
    Replies: 2
    Last Post: January 15th, 2004, 02:06 AM
  2. Explanation of sorting in english, please
    By NelsonN in forum Perl Programming
    Replies: 4
    Last Post: November 2nd, 2003, 01:51 PM
  3. sorting and quit in the middle
    By Rooseboom in forum PHP Development
    Replies: 25
    Last Post: May 21st, 2003, 01:01 PM
  4. Problem with sorting the result on a VARCHAR field
    By mehran20 in forum MySQL Help
    Replies: 0
    Last Post: December 25th, 2002, 10:26 PM
  5. 2 sorting questions
    By dwh in forum MySQL Help
    Replies: 2
    Last Post: May 5th, 2002, 10:11 PM

IMN logo majestic logo threadwatch logo seochat tools logo