Hello everyone, It seems as though I am unable to perform an order by with a
DATETIME field when the column is named as an alias. For example...
SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents
ORDER by 'Serv. Date' DESC LIMIT 0,10;
Can anyone give me an explanation?
Periods are not allowed in field names.
Dave Juntgen wrote:
Hello everyone, It seems as though I am unable to perform an order by with a
DATETIME field when the column is named as an alias. For example...
SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents
ORDER
PROTECTED]
To: "Dave Juntgen" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 1:41 PM
Subject: Re: Order by using alias?
Periods are not allowed in field names.
Dave Juntgen wrote:
Hello everyone, It seems as though I am unable to perform an order by
with a