Professional Web Applications Themes

Weird problem of storing the data format - ASP Database

I am using MS Access as my data source. The date field was originally set to dd/mm/yyyy format and the server of regional setting as well. Recently I have changed both date format to dd/mm/yyyy. When I try to input the data using adodb.recordset, it still store the data fomrat to mm/dd/yyyy. Pleae help !...

  1. #1

    Default Weird problem of storing the data format

    I am using MS Access as my data source. The date field
    was originally set to dd/mm/yyyy format and the server of
    regional setting as well. Recently I have changed both
    date format to dd/mm/yyyy. When I try to input the data
    using adodb.recordset, it still store the data fomrat to
    mm/dd/yyyy. Pleae help !
    rick Guest

  2. #2

    Default Re: Weird problem of storing the data format

    rick wrote:
    > I am using MS Access as my data source. The date field
    > was originally set to dd/mm/yyyy format and the server of
    > regional setting as well. Recently I have changed both
    > date format to dd/mm/yyyy. When I try to input the data
    > using adodb.recordset, it still store the data fomrat to
    > mm/dd/yyyy. Pleae help !
    Access does not store dates with any format. The Format setting only affects
    how the dates are displayed.

    Dates are stored as Doubles, with the whole number portion reflecting the
    number of days since a seed date, and the decimal portion reflecting the
    time of day (.5 = noon). All formatting is done by the client application.

    [url]http://www.aspfaq.com/show.asp?id=2260[/url]

    Bob Barrows
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Barrows Guest

Similar Threads

  1. DataSet not storing any data?
    By Vanth SpiritWalker in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: October 19th, 12:30 PM
  2. Linking data, searching data, and format the data file
    By CobraC081375 in forum Macromedia Flash Data Integration
    Replies: 5
    Last Post: January 5th, 09:54 PM
  3. Storing and Retriving Data Locally
    By The Other White Meat in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: June 20th, 05:26 PM
  4. Storing encrypted data
    By K Old in forum PERL Beginners
    Replies: 0
    Last Post: August 31st, 03:15 AM
  5. Storing data in a table from a form
    By D Kucey in forum Microsoft Access
    Replies: 2
    Last Post: July 9th, 02:59 AM

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