<cfquery name="qryDate" datasource="#request.dsn#"> Select convert(float,getdate()) as datetimefromdb </cfquery>
<cfoutput query="qryDate"> display that with: #val(datetimefromdb - 0)# Returns 38734.6939544 (or whatever date/time it is) display that with: #dateformat(val(datetimefromdb-0), "dd-mmm-yy")# Returns 17-Jan-06 (what? thats 2 days ago) </cfoutput> Now use select getdate() as datetimefromdb in your Query <cfquery name=qryDate" datasource="#request.dsn#"> select getdate() as datetimefromdb </cfquery> <cfoutput query="qryDate"> display that with: #val(datetimefromdb - 0)# Returns 38736.6939468 (hrm differen date) display that with: #dateformat(val(datetimefromdb-0), "dd-mmm-yy")# Returns 19-Jan-06 (success todays date) </cfoutput> But why would i get 2 different dates? -- Richard Dillman "The most important step is always the first one." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230056 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
