Professional Web Applications Themes

Wrong dateformat - ASP Database

Hello I was wondering if you could help me help someone im supporting :) He has a sql 2000 db he connects to and selects from a table that has a datetime column. His sql-user has swedish as language but when he uses <%=formatdatetime(rs("mydate"),2)%> in his asp-page still it shows as american format and not yyyy-mm-dd what might be wrong? /Lasse...

  1. #1

    Default Wrong dateformat

    Hello

    I was wondering if you could help me help someone im supporting :)

    He has a sql 2000 db he connects to and selects from a table that has a
    datetime column. His sql-user has swedish as language but when he uses
    <%=formatdatetime(rs("mydate"),2)%> in his asp-page still it shows as
    american format and not yyyy-mm-dd

    what might be wrong?
    /Lasse


    Lasse Guest

  2. #2

    Default Re: Wrong dateformat

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


    John Guest

  3. #3

    Default Re: Wrong dateformat

    John,

    thx, found out that he had wrong collation on db

    /Lasse


    "John" <n o b o d com> wrote in message
    news:1d.245524$telenet-ops.be... 


    Lasse Guest

Similar Threads

  1. DateFormat in cfquery
    By EINN in forum Coldfusion - Getting Started
    Replies: 7
    Last Post: September 2nd, 08:47 PM
  2. Add To Dateformat()
    By bweno in forum Macromedia ColdFusion
    Replies: 1
    Last Post: June 29th, 01:22 AM
  3. Dateformat question
    By Steve Grosz in forum Macromedia ColdFusion
    Replies: 2
    Last Post: May 25th, 12:32 AM
  4. dateformat - month
    By Mattastic in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: April 21st, 03:05 PM
  5. DateFormat?
    By RP in forum ASP
    Replies: 1
    Last Post: July 8th, 07:50 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