Professional Web Applications Themes

Updating DateTime? - ASP Database

Help! How does one UPDATE date and time field in Sql server: Eg: u_ExpiryDate = 8/25/2004 3:40:48 If I try this: UPDATE t_user SET u_ExpiryDate = 8/25/2004 3:40:48 WHERE u_ID > 1 I pick up an error. Appreciate replies Thanks Jason...

  1. #1

    Default Updating DateTime?

    Help! How does one UPDATE date and time field in Sql server:

    Eg: u_ExpiryDate = 8/25/2004 3:40:48


    If I try this:

    UPDATE t_user
    SET u_ExpiryDate = 8/25/2004 3:40:48
    WHERE u_ID > 1

    I pick up an error.

    Appreciate replies

    Thanks
    Jason


    Guest

  2. #2

    Default Re: Updating DateTime?

    http://www.aspfaq.com/2023

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    <com> wrote in message
    news:phx.gbl... 


    Aaron Guest

  3. #3

    Default Re: Updating DateTime?

    com wrote: 

    http://www.aspfaq.com/show.asp?id=2313 vbscript
    http://www.aspfaq.com/show.asp?id=2040 help with dates
    http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion

    Basically, dates should be supplied to sql in unambiguous format (yyyymmdd
    hh:mm:ss), and they should be quote-delimited. Of course, using parameters
    relieves you of the necessity to worry about delimiters.

    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 Guest

  4. #4

    Default Re: Updating DateTime?

    Aaron [SQL Server MVP] wrote: 
    Damn! How did I miss that one?
    Bob
    --
    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 Guest

  5. #5

    Default Re: Updating DateTime?

    Thanks
    "Aaron [SQL Server MVP]" <noraa> wrote in message
    news:eJ%phx.gbl... 
    >
    >[/ref]


    Guest

  6. #6

    Default Re: Updating DateTime?

    Thanks got it.

    "Bob Barrows [MVP]" <SPAMcom> wrote in message
    news:phx.gbl... 
    >
    > http://www.aspfaq.com/show.asp?id=2313 vbscript
    > http://www.aspfaq.com/show.asp?id=2040 help with dates
    > http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion
    >
    > Basically, dates should be supplied to sql in unambiguous format (yyyymmdd
    > hh:mm:ss), and they should be quote-delimited. Of course, using parameters
    > relieves you of the necessity to worry about delimiters.
    >
    > 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.
    >
    >[/ref]


    Guest

Similar Threads

  1. Updating Updating site map or archive dynamically
    By RooZam in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: September 15th, 04:45 PM
  2. MySQL datetime record not updating with DW toolbox
    By planethead in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 2
    Last Post: August 13th, 07:05 PM
  3. Need help updating SQL DateTime fields.
    By Sh1rp in forum Macromedia ColdFusion
    Replies: 4
    Last Post: March 31st, 09:22 PM
  4. Updating AI Files causes position to 'bounce' when updating in Quark
    By Chris_Tod@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 1
    Last Post: May 6th, 07:29 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