Skip to main content
Participant
October 11, 2006
Question

Output time format

  • October 11, 2006
  • 2 replies
  • 253 views
Dear all:
When i run the code above on CF5(windows) ,CF6(linux),and CF7(linux)
[Q<cfquery name="ss" datasource="#test#">
select date from jn where no = 103
</cfquery>
<cfoutput>#ss.date#</cfoutput>


result as:
cf 5 on windows
quote:

2006-01-19 13:48:00


cf mx on linux
quote:

2006-01-19 13:48:00.0


cf mx7 on linux
quote:

2006-01-19 13:48:00.0


my question is why CF6 & CF7 show ".0"
can i change this without adjust code?
    This topic has been closed for replies.

    2 replies

    angusfzAuthor
    Participant
    October 12, 2006
    thanks for Dan Bracuk's recommand
    because we are migrating from cf5 to cf7
    it needed to take many time to adjust code
    so ,without adjusting code
    any solution or suggestion will be appreciated...^^
    Inspiring
    October 11, 2006
    I recommend adjusting your code so that you don't have to worry about operating systems and versions.