Hi I have written following code to display date.. <cfquery name="getDate" datasource="DSN_Test"> select D_DATE from employee </cfquery> <cfoutput query="getDate" > #D_DATE# </cfoutput> but in CFMX environment it shows : 2003-04-30 00:00:00.0 (milli seconds format.. Its java locale standard date format. Default format.) In CF5.0 Environment it shows : 04/30/2003 00:00:00 (normal format) So here my question is that can we change this default milliseconds format to normal format in CFMX environment with out writing the code.. I know that we can write the code to convert one format to another..but we have a lot of places in another files.. so is there any file where we can change default format to normal format in globally.. it should reflect in all cfm pages too.. Thanks in Advance.. Best regards Ramesh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
