trouble to insert date into the database

Results 1 to 2 of 2

Thread: trouble to insert date into the database

  1. #1
    Join Date
    Dec 1969
    Posts
    100

    Default trouble to insert date into the database

    I am new to ASP and I have a problem to insert a record into the database.The record consists a date field.While I insert the record it&#039s giving me an error<BR> "Syntax error converting DATETIME from character string." <BR>Can any one please help me in this regard.<BR>Thanks in advance<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    572

    Default RE: trouble to insert date into the database

    First of all make your field Date/Time,<BR>then in your ASP page use someting like that:<BR>lastupdate= Now()<BR>yourconnection.Fields("LastUpdate")=lastu pdate

Posting Permissions

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