Results 1 to 17 of 17
Thread: TimeStamp Question/Problem
May 24, 2001, 12:24 #1
- Join Date
- May 2001
- San Diego, CA
- 0 Post(s)
- 0 Thread(s)
I have a table with two timestamp(14) fields called add_date and updated. When I insert a new entry I want the current date/time set into these two fields. When I update the entry I only want the updated field to change. The problem is that everytime I update the entry, both fields' timestamps are changed.
When I do an UPDATE query, I set updated = now()
My settings for both fields are timestamp(14) and fields can be NULL.
Any ideals on what I'm doing wrong?