Results 1 to 2 of 2

Thread: hour??

  1. Nov 9th, 2000, 02:02 PM #1
    farizza
    farizza is offline

    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????
    Reply With Quote Reply With Quote
  2. Nov 9th, 2000, 02:19 PM #2
    courchjo
    courchjo is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width