#1
  1. No Profile Picture
    chinnavi
    Guest
    Devshed Newbie (0 - 499 posts)
    hai

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

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

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    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