Returning Dates -- Need to get rid of the time

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Re: Returning Dates -- Need to get rid of the time

    i tried that a few different ways but to no avail. my web page still shows the time.
    coryd218 Guest

  2. Similar Questions and Discussions

    1. FLV returning different "time" and "duration"
      So, I have a strange problem. I am advancing a Flash movie based on when the FLV that is dynamically loaded, is finished playing. I have the...
    2. CFMX7.0.1 Administrator date time issue showing 13hrsbehind server time
      I am running a W2k SP4 box that has been upgraded from CFMX6 to CFMX7.0.1. The CFMX7.0.1 server is showing the date on the Server Settings >...
    3. phpinfo returning 2 different build dates
      Hi, My host keeps messing things up and not telling me. I am trying to write a cron job that will test to make sure the "unusual" functions I...
    4. Help with Dates please
      Hi, In a SQL table I have a field named departure and a date in inserted in it. What is the exact syntax to get only records with a future date...
  3. #2

    Default Re: Returning Dates -- Need to get rid of the time

    If you want to do this in the web page then apply the dateformat to the column
    from the query.

    It looks as though m16 is a date/time data type, so you would do the following
    in your page

    <cfoutput query="GetTraining">
    #dateFormat(GetTraining.m16, "mm/dd/yyyy") #
    </cfoutput>

    Ken

    The ScareCrow Guest

  4. #3

    Default Re: Returning Dates -- Need to get rid of the time

    THANKS!!!!!!!!!
    coryd218 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139