SQL query, ch_to , date and aliases [message #1411] |
Fri, 26 April 2002 15:16 |
Gemma Bruce
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
can someone help me i am trying to write a query at the moment so far this is what it looks like
SELECT ENAME "NAME", TO_CHAR((EDATE "DATE"),'fmDAY MONTH YYYY')EDATE, LOCATION "EVENT LOCATION"
FROM GSB_EVENT
WHERE EDATE > '01-JAN-01' ORDER BY EDATE, BUDGET
its not working though i need to change the name of the column edate to date i have tried as above but this isnt working. Anyone that can help i would appreciate it, please email me. thankyou Gemma
|
|
|
Re: SQL query, ch_to , date and aliases [message #1414 is a reply to message #1411] |
Fri, 26 April 2002 21:47 |
Saga
Messages: 51 Registered: April 2002
|
Member |
|
|
Try using the following query instead
SELECT ENAME "NAME", TO_CHAR( EDATE ,'fmDAY MONTH YYYY') "DATE" , LOCATION "EVENT LOCATION"
FROM GSB_EVENT
WHERE EDATE > '01-JAN-01' ORDER BY EDATE, BUDGET
Hope it helps
|
|
|