Results 1 to 3 of 3

Thread: hour

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

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

    Unhappy

    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:28 PM #2
    HeSaidJoe
    HeSaidJoe is offline
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    check the format of the field in the database you are saving it to. It would have to be the same as the textbox format.
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."
    ___ Adolf Jensen
    Reply With Quote Reply With Quote
  3. Nov 9th, 2000, 03:30 PM #3
    Guest
    In a format string, 'm' is for months. Use 'n' for minutes like so:

    Format$(Now, "hh:nn:ss")


    Paul
    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