| Subject | Re: Order by (Date minus Date) |
|---|---|
| Author | ai_no_kareshi |
| Post date | 2008-01-21T07:51:46Z |
That solved my problem. I thought it had to have something to do with
casting, but I just couldn't get it to work. Thank you so much!
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:
casting, but I just couldn't get it to work. Thank you so much!
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@...> wrote:
>PeriodLength
> SELECT P.PeriodName, cast('2008-01-21' as Date) - P.StartDate AS
> FROM Periods P
> ORDER BY 2 DESC