Results 1 to 2 of 2

Thread: hour??

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 2000
    Location
    Panama
    Posts
    17

    Arrow

    hello
    i have a textbox in the form load i write
    Format$(time, "hh:mm:ss").
    when i insert this in the database(SQL Server7)
    insert this 1/1/1900 12:30:55 actual hour

    what is the problem????

  2. #2
    Addicted Member
    Join Date
    Apr 1999
    Location
    Atlanta
    Posts
    145
    I had that problem earlier and do like this with no problem:
    strSQL = strSQL & chr(39) + Format(Time, "hh:mm:ss") + chr(39)

    Joe

Posting Permissions

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



Click Here to Expand Forum to Full Width