Sorting by date time in descending order

Question

all          I want to display last 5 entered data for specific id  My sql query is   SELECT id  name  form id  DATE updated at  as date   FROM wp frm items   WHERE user id   11  amp  amp  form id 9   ORDER BY updated at DESC   updated at is DATETIME  It displays last 5 entry sort by date not by time  On same date then it is sorting alphabetically   Suppose i have 3 entries in same date with diff time  let s say  Ajay 1 3 2012 1 15 John 1 3 2012 1 00 Bony 1 3 2012 1 10   after querying the above query   what i got is   Ajay 1 3 2012 1 15 Bony 1 3 2012 1 10 John 1 3 2012 1 00   Sort by date then after alphabetically  What i want is this    John 1 3 2012 1 00 Bony 1 3 2012 1 10 Ajay 1 3 2012 1 15   Sorted by date and time also

User · Answer

I used a simpler solution found partly here:
How to sort details with Date and time in sql server ?
I used this query to get my results:

SELECT TOP (5) * FROM My_Table_Name WHERE id=WhateverValueINeed ORDER BY DateTimeColumnName DESC

This is more straight forward and worked for me.

Notice: the column of the Date has the "datetime" type

User · Answer

SELECT id  name  form id  DATE updated at  as date FROM wp frm items WHERE user id   11  amp  amp  form id 9 ORDER BY date ASC    DESC  stands for descending but you need ascending order   ASC

User · Answer

SELECT   FROM                  SELECT id  name  form id  DATE updated at  as date                FROM wp frm items                WHERE user id   11  amp  amp  form id 9                ORDER BY updated at DESC                AS TEMP     ORDER BY DATE updated at  DESC  name DESC   Give it a try

User · Answer

If you want the last 5 rows  ordered in ascending order  you need a subquery   SELECT   FROM       SELECT id  name  form id  DATE updated at  AS updated date  updated at       FROM wp frm items       WHERE user id   11          AND form id 9       ORDER BY updated at DESC       LIMIT 5       AS tmp ORDER BY updated at     After reading the question for 10th time  this may be  just maybe  what you want  Order by Date descending and then order by time  on same date  ascending   SELECT id  name  form id  DATE updated at  AS updated date FROM wp frm items WHERE user id   11    AND form id 9 ORDER BY DATE updated at  DESC          updated at ASC

User · Answer

putting the UNIX TIMESTAMP will do the trick   SELECT id  NAME  form id  UNIX TIMESTAMP updated at  AS DATE     FROM wp frm items     WHERE user id   11  amp  amp  form id 9     ORDER BY DATE DESC

User · Answer

If you mean you want to sort by date first then by names  SELECT id  name  form id  DATE updated at  as date   FROM wp frm items   WHERE user id   11  amp  amp  form id 9   ORDER BY updated at DESC name ASC   This will sort the records by date first  then by names

User · Answer

Following Query works for me  Database Tabel t sonde results has domain d date  datatype DATE  and d time  datatype TIME  The intention is to query for last entry in t sonde results sorted by Date and Time  select   from  select   from  SELECT   FROM t sonde results WHERE d user name    kenis  and d smartbox id   6 order by d time asc   AS tmp order by d date and d time limit 1  as tmp1

User · Answer

This is one of the simplest ways to sort record by Date   SELECT   Article Id      Title      Source Link      Content      Source     Reg Date   UNIX TIMESTAMP    Reg Date    AS DATE FROM article ORDER BY DATE DESC

[mysql] Sorting by date & time in descending order?

Examples related to mysql

Examples related to sql