timestamp datatype

Results 1 to 2 of 2

Thread: timestamp datatype

  1. #1
    Join Date
    Dec 1969

    Default timestamp datatype

    can anyone explain how to use the timestamp datatype in SQL Server 7. I want to timestamp each entry into the database, this seems like the logical way.<BR><BR>thanks,<BR><BR>geoff

  2. #2
    DL Guest

    Default RE: timestamp datatype

    I&#039ve never used it but what you can do is create a smalldatetime datatype field and give it the default of getdate(). This will insert the date/time into the field when you do an insert.

Posting Permissions

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