Look at the date and time functions. They now support milliseconds. You need to know, in your system, what 0 milliseconds is equal to. It may be Jan 1, 1970. That will give you a datum from which you can caculate your dates.
I don't have access to a server right now, or I would try it myself. M!ke -----Original Message----- From: Jim Rathmann [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 12:22 PM To: CF-Talk Subject: Convert Milliseconds to Date/Time I have a question that I am not sure if ColdFusion can calculate. Is there any way to convert a Date/Time field that is in Milliseconds to a readable Date/Time using ColdFusion? You can do it using the following JavaScript: var theDateObj = new Date(parseFloat(1108389720000)); var d = theDateObj.toLocaleString(); and the result is: "Monday, February 14, 2005 9:02:00 AM" I don't want to convert it with JS I would like to try it with CF. If anyone could help it would be much appreciated thanks. Thanks, Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4:204775 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
