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 13:11 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: How to get timestamp of inserted record Hello all, 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...what i have to do...i have to mention the current timestamp value with values of all fields of a record or is there any way to insert new record so that it will automatically take current timestamp for that record. Plz specify the sql query also, if u know right now. Thx in advance. Rgds, Jenny __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.380 / Virus Database: 213 - Release Date: 24-07-2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.380 / Virus Database: 213 - Release Date: 24-07-2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php