Question
Date question
I have pulldown that I populate dynamically. I use this query
:
<cfquery name="qry" datasource="db">
select distinct
substring(convert(varchar,EmailDate,101), 1, 2) as month
from test_norsMaster
where eMailDate is not NULL
order by month
</cfquery>
I gives me the month as 01, 02, etc. How can I convert the month extract to be January, February, etc ?
Thanks
<cfquery name="qry" datasource="db">
select distinct
substring(convert(varchar,EmailDate,101), 1, 2) as month
from test_norsMaster
where eMailDate is not NULL
order by month
</cfquery>
I gives me the month as 01, 02, etc. How can I convert the month extract to be January, February, etc ?
Thanks
