If I set a column (say Last_Login) to type=>'date' then this just records the date?
If I set this column to type=>'timestamp' then this records the date and the time each time the record is accessed, right??
I want to set this column with the current date/time only when something else is true, like with my Last_Login for when I user logs in.
I understand there is a DATETIME type used in the LSQL Links table (default 0000-00-00 00:00:00).
So I guess my question is, how do I set a column with the DATETIME field to the current DATETIME reported by the server (only when a condition is true, not automatically like timestamp)?
Pheww.. I hope that makes sense.
http://www.iuni.com/...tware/web/index.html
Links Plugins
If I set this column to type=>'timestamp' then this records the date and the time each time the record is accessed, right??
I want to set this column with the current date/time only when something else is true, like with my Last_Login for when I user logs in.
I understand there is a DATETIME type used in the LSQL Links table (default 0000-00-00 00:00:00).
So I guess my question is, how do I set a column with the DATETIME field to the current DATETIME reported by the server (only when a condition is true, not automatically like timestamp)?
Pheww.. I hope that makes sense.
http://www.iuni.com/...tware/web/index.html
Links Plugins
Date and Time fields Questions