Hi all, How would I insert a timestamp into a second timestamp field in a table when creating a new record. I have a 'modified' timestamp field first. It is timestamped automatically when it is created and updated. I also have a 'created' timestamp field, which needs to be timestamped when the record is created with the same value as in the 'modified' field. How to do?
you are doing it wrong. Use the modified as a true timestamp and use a datetime for the created becaeuse it will never change.
you make a good point. However, is there a way to update two timestamps at the same time?
yea, do it by hand. If you RTFM, you will see that you can only have one timestamp updated automaticly per table. This is true in every database I've worked in (oracle, mssql, sybase, mysql...)
