Post reply

Datetime / Timestamp

  • May 28, 2008 at 12:56 pm

    #187189

    I am in need of a Timestamp for the creation of a record, do I use Datetime and set =Now() , or do I use Timestamp? Once the date & Time have been set I do not want that record field to change again.

    Thanks

  • May 28, 2008 at 1:30 pm

    #821420

    Use a datetime and have the default value be GETDATE(). A timestamp is a binary value that changes every time the row is updated - useful if you want to know if a row changed, but it doesn't tell you when it changed.

    Hope this helps!

    Chad

  • May 28, 2008 at 1:44 pm

    #821427

    Thanks, it does. I'm a novice and need a crash course to get our Database up and running right.

    By the way, how do I set a field default to capture the Computer name of the staff member who is adding the record, we used to use =Environ("ComputerName") in Access 2003.

    Appreciate any feed back.

    Pete

  • May 28, 2008 at 4:03 pm

    #821493

    HOST_NAME()

    _____________
    Code for TallyGenerator

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply