Order by date and then time

[Robert Orlini]

I would like to order first by datechanged and then by the time it was changed. I have so far this code:

<CFQUERY name="logdata" datasource="wweb_status">
Select * from statuslog
Order by datechanged desc
</CFQUERY>

It orders correctly by date changed. For example, if multiple changes were made today, 3/15/2004, how do I then tell it to order by the time to the very first item?

Thanks.

Robert
HWW

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---