| Subject | Re: Order by (Date minus Date) |
|---|---|
| Author | ai_no_kareshi |
| Post date | 2008-01-21T07:38:19Z |
Gosh, you're right. It does work. My bad. On to the next question,
then. The following query really doesn't work.
SELECT P.PeriodName, ('2008/01/21' - P.StartDate) AS PeriodLength
FROM Periods P
ORDER BY 2 DESC
Could you help me get this working with date literals?
then. The following query really doesn't work.
SELECT P.PeriodName, ('2008/01/21' - P.StartDate) AS PeriodLength
FROM Periods P
ORDER BY 2 DESC
Could you help me get this working with date literals?