Re: [SQL] Funny date-sorting task

2007-05-13 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > Every task has a timestamp X that may be NULL or a date. > ... > Sometimes it has date and the time-part, too. > > The list should be like this: > 1) X sometime today should come first in ascending time order. > 2) X in the past shoul

Re: [SQL] Funny date-sorting task

2007-05-13 Thread Rodrigo De León
On 5/12/07, Frank Bax <[EMAIL PROTECTED]> wrote: At 07:40 PM 5/12/07, Andreas wrote: >I've got a stack of tasks to show in a list. >Every task has a timestamp X that may be NULL or a date. It contains the >date when this tasks should be done. >Sometimes it has date and the time-part, too. > > >

Re: [SQL] Funny date-sorting task

2007-05-12 Thread Frank Bax
At 07:40 PM 5/12/07, Andreas wrote: I've got a stack of tasks to show in a list. Every task has a timestamp X that may be NULL or a date. It contains the date when this tasks should be done. Sometimes it has date and the time-part, too. The list should be like this: 1) X sometime today s

[SQL] Funny date-sorting task

2007-05-12 Thread Andreas
Hi, I've got a stack of tasks to show in a list. Every task has a timestamp X that may be NULL or a date. It contains the date when this tasks should be done. Sometimes it has date and the time-part, too. The list should be like this: 1) X sometime today should come first in ascending ti