If you want to format a date as it comes out of the database, you can
use to_char(yourdatefield, 'yourdatemask'). If not, it'll just come
out in the default format, and you can still format it in cf with
dateformat(). In other words, it's optional, and just selecting the
date will work fine.
As Jochem said, for inserting, use cfqueryparam, and you'll be good.
If you're not using CF, then, yes, you can use
to_date('yourdatestring', 'yourdateformat')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:146420
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
