how to order by Time

I try to use

sql=select * from ArticleTable order by xTime

but my time form : "3/18/2005 5:23:58 PM"

and "order by xTime" urns very strange range

do I have to reform all the time?

Please help!

 

is it a datetime type in your DB?

 

i use <% =now %>
and i save it as normal txt (type is same as article name field)
so it looks like this "3/18/2005 5:23:58 PM" in DB

 

you should have DATETIME type not TEXT so that you can sort it the way you need

but now when you get the string, you need to convert it to a DATETIME value, but it'll be harder, in place of that change the data type to DATETIME

 

Try:

sql="select * from ArticleTable order by cast(xTime as datetime)"

This converts the text value to a datetime, and sorts it as a datetime.

 

BurgerKing,

Thank you so much.
It works now.

But
However I also try <%=cast(rsL("xTime") as datetime)%> <-- do not work!!!
what does it look like after CAST?
length for xTime shall be longer than Datetime or same?

Please help.

 

Cast is a SQL Server command and will not work in vb/vbscript