Posted by richard.a.fletcher@googlemail.com on 10/14/77 11:45

Does this help? (I tend to use postgresql so now() may be something
like today() or whatever).

select case when created-now()<86400 then 1 else 0 end as priority from
jobs .... order by priority desc, created desc.

• Next in forum: Re: Phpmyadmin instalation - Cannot modify header information
• Prev in forum: Re: Query oci_parse() Apache error
• Thread view: Re: How to sort date based on Today

[Reply to this message]