Zeradin Posted September 9, 2008 Share Posted September 9, 2008 I was wondering if someone could explain timestamps to me... with the "current timestamp" etc that's what i use currently, but i was wondering if i could use that for timestamp and then another kind to just log when the entry was first created, not when it was last updated. are there other types of timestamps that do other things in sql? thanks Quote Link to comment Share on other sites More sharing options...
Mchl Posted September 9, 2008 Share Posted September 9, 2008 You can have many TIMESTAMP columns within one table, but the first one can have two special properties one is ON UPDATE CURRENT TIMESTAMP which automatically updates timestamp whenever row is upadted second is DEFAULT CURRENT TIMESTAMP which inserts current timestamp when row is created second and later TIMESTAMP columns can't have these properties and you can use them to store the time you wish Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.