[thelist] select
Scott Dexter
sgd at ti3.com
Tue Jan 9 19:17:26 CST 2001
what is the datatype of the field?
if its a datetime datatype, there's no problem:
select ... from ... where ... order by datefield
if you don't have it in the database as a date datatype, yer, um, pooched.
Time to convert the field....
sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/
> -----Original Message-----
> From: Andrew Martin [mailto:comitque at hotmail.com]
>
> is there to get the results of a sql query to sort by actual
> date instead
> of numbered date? for instance, right now it will give:
>
> 1/12/2000
> 12/03/2000
> 7/06/2000
> 9/04/2000
>
> instead of:
>
> 1/12/2000
> 7/06/2000
> 9/04/2000
> 12/03/2000
>
> any suggestions? btw, i'm using asp if that makes a
> difference... thanks!
More information about the thelist
mailing list