>>we use mysql 5.0 and it does store the date as yyyy/mm/dd.
This this actually how your database will *display* the date, but
internally, it is stored as a 3 bytes integer value.
(see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html )
But are you sure the field is defined as a *date* type, or as a string?
Anyway, CF should be able to recognize the format even if it is passed
as a string from the query.
I'v tried this code, and it works wit no problem under CF 5 ans CF 7 :
<cfset SetLocale("English (UK)")>
<CFSET date1 = "16/01/1990">
<CFSET date2 = "01/16/1990">
<CFSET date3 = "1990/01/16">
<CFOUTPUT>
dateFormat(date1, "dd/mm/yyyy") = #dateFormat(date1, "dd/mm/yyyy")#<BR>
dateFormat(date2, "dd/mm/yyyy") = #dateFormat(date1, "dd/mm/yyyy")#<BR>
dateFormat(date3, "dd/mm/yyyy") = #dateFormat(date1, "dd/mm/yyyy")#<BR>
LSdateFormat(date1, "dd/mm/yyyy") = #LSdateFormat(date1, "dd/mm/yyyy")#<BR>
LSdateFormat(date2, "dd/mm/yyyy") = #LSdateFormat(date1, "dd/mm/yyyy")#<BR>
LSdateFormat(date3, "dd/mm/yyyy") = #LSdateFormat(date1, "dd/mm/yyyy")#<BR>
</CFOUTPUT>
>>if i put exactly the same code but take out the ls then it works fine
Weird indeed.
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296930
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
