RE: How to get timestamp of inserted record

2002-07-30 Thread Ed Carp
> suppose I have added one field time_stamp of type > timestamp in any existing table. it will show the > current timestamp of all records. If i update any > record after sometime It will also update the > timestamp of updated record with current timestamp. > > but for insertion of any record...w

RE: How to get timestamp of inserted record

2002-07-30 Thread toby -
jenny >suppose I have added one field time_stamp of type >timestamp in any existing table. it will show the >current timestamp of all records. If i update any >record after sometime It will also update the >timestamp of updated record with current timestamp. > >but for insertion of any recor

RE: How to get timestamp of inserted record

2002-07-30 Thread Peter Normann
Hi Jenny, I believe that the timestamp field will automatically be set to NOW() when you INSERT a record... In other words, you can disregard the timestamp field in the INSERT query Peter Normann -Original Message- From: Jenny Christy [mailto:[EMAIL PROTECTED]] Sent: 30. juli 2002