Results 1 to 4 of 4

Thread: Timestamp

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    Timestamp

    Hi all,

    I have web site and I want to Keeping track who login site. how to handle in database?
    Thank you!
    ________
    MONTANA MEDICAL MARIJUANA
    Last edited by sql; 03-06-2011 at 01:36 AM.

  2. #2
    Join Date
    May 2004
    Posts
    12
    You can use timestamp in the column value. Or else you can insert the getdate() value to insert the date and time into your columns using sql or stored procedures. This will keep track of the users logged into your web site.

  3. #3
    Join Date
    Feb 2003
    Posts
    1,048
    You will also need to track when they log out or their session times out.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Remember that timestamp data type in SQL Server is not actuallly a date time.

Posting Permissions

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