Hello,
How can I format a date when selecting rows in a query ?
<cfquery name="qNews" datasource="db_niteriders"
username="webdevo_adm" password="251984">
select id, title, short, content,
DATE_FORMAT(date,'%d-%m-%Y') from tbl_news
</cfquery>
is this the way to do it when using components ?
Bram
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186661
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
