Results 1 to 5 of 5

Thread: Timestamp Field

  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Unanswered: Timestamp Field

    Hello !

    I need to record date & time when a new record is added ot the field is updated.

    I have used the timestamp value which shows as 'binary' when the row is updated but does not show the date.

    Can anyone help please ?

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    which database?

  3. #3
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Itīs always the same ... everybody thinks his database system is the one and only

  4. #4
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113
    Originally posted by r937
    which database?
    SQL 7 - sorry !

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Use getdate or getutcdate.

Posting Permissions

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