Professional Web Applications Themes

MX formating date differently than 5 with Oracle - Coldfusion Database Access

All, We are in the process of migrating from CF5 to CFMX7. In cold fusion 5, with an oracle databases dates are returned in the following format: "05-Apr-03", however with the same database on our new MX7 servers the dates are being returned in this format: "2003-04-05 00:00:00.0". The problem is when we take the date and try to run another query using it oracle gives an error stating that it is not a valid date(because that format isn't a valid oracle date). Can someone tell me if there is a server setting or something I'm missing that would allow ...

  1. #1

    Default MX formating date differently than 5 with Oracle

    All,

    We are in the process of migrating from CF5 to CFMX7. In cold fusion 5, with
    an oracle databases dates are returned in the following format: "05-Apr-03",
    however with the same database on our new MX7 servers the dates are being
    returned in this format: "2003-04-05 00:00:00.0".

    The problem is when we take the date and try to run another query using it
    oracle gives an error stating that it is not a valid date(because that format
    isn't a valid oracle date).

    Can someone tell me if there is a server setting or something I'm missing that
    would allow us to force cold fusion to use the correct oracle date format
    without changing the code?

    Thanks,
    Rob

    flesher_rob Guest

  2. #2

    Default Re: MX formating date differently than 5 with Oracle

    #createodbcdatetime(yourdate)#
    TurboMini Guest

  3. #3

    Default Re: MX formating date differently than 5 with Oracle

    Phil,

    Thanks for your reply, but we're trying to find a solution without changing
    the code. This would be a pretty large effort if we had to change the code in
    every place this existed. Do you have any other suggestions?

    Thanks,
    Rob

    flesher_rob Guest

  4. #4

    Default Re: MX formating date differently than 5 with Oracle

    How about the same suggestion from another person? In fact, you are going to
    have to do something about this date thing everywhere you pull a date from
    pretty well any database.

    Just like we had to.

    Dan Bracuk Guest

  5. #5

    Default Re: MX formating date differently than 5 with Oracle

    homesite/dreamweaver find-replace feature is your buddy :)
    A3gis Guest

Similar Threads

  1. Formating Date
    By LJG in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 3
    Last Post: August 22nd, 05:02 PM
  2. Date formating in DataGrid
    By Maged in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: November 24th, 02:00 AM
  3. Date Formating
    By Seli in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: March 4th, 08:15 PM
  4. [PHP] formating date
    By Peter Knight in forum PHP Development
    Replies: 0
    Last Post: July 30th, 04:07 PM
  5. Formating date,time
    By Deuvenx in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 26th, 03:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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