Dates and Times

Results 1 to 4 of 4

Thread: Dates and Times

  1. #1
    Join Date
    Dec 1969

    Default Dates and Times

    I am creating a asp forum and when a user replies to a message I have a SQL statement entering the current date and time that works fine followed by a SQL statement that updates the LastPostDate with the current date except that for some unknown reason the date comes up as 30/12/1899 and it also inserts a time in the LastPostTime even though i&#039ve not asked it to. <BR>I have done a repsonse.write statement and the SQL is correct. <BR>Any Ideas?

  2. #2
    Forum Police Guest

    Default CROSSPOST

    Do not post the same question in multiple forums.

  3. #3
    Chris Surfleet Guest

    Default RE: Dates and Times - show us your SQL

    Show your sql - do you use the vbscript date value or the sql version?

  4. #4
    Join Date
    Dec 1969

    Default RE: Dates and Times - show us your SQL

    Conn.Execute "UPDATE messages SET LastPostDate = "&Date&" WHERE messageID = "&messageID<BR><BR>I have tried numerous different ways of representing the date in the SQL statement but still get 30/12/1899.

Posting Permissions

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