--- [EMAIL PROTECTED] wrote:
> I need to sort the query by the log_date desc
> (log_date is char(10)). I
> tried the following without success :
>
> select id, log_date from userlog order by cast
> (log_date as date) desc
>
> select id, log_date from userlog order by
> date(log_date) desc
>
>
On Thu, 12 Sep 2002 [EMAIL PROTECTED] wrote:
>
> Hello there
>
> Unfortunately, I can't change the fieldtype that easy because other
> applications use the date as char(10) field as well.
>
> I need to sort the query by the log_date desc (log_date is char(10)). I
> tried the following without suc
Hello there
Unfortunately, I can't change the fieldtype that easy because other
applications use the date as char(10) field as well.
I need to sort the query by the log_date desc (log_date is char(10)). I
tried the following without success :
select id, log_date from userlog order by cast (log
