Re: date help
| From: | Andreas D. Landmark | Date: | Sat, 17 Nov 2001 16:06:20 +0000 |
| Subject: | Re: date help | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14415@lists.php.net to get a copy of this message | ||
At 17.11.2001 14:45, Srinivasan Ranganathan wrote:
Hi I need to store the date and time of sign-up and date and time of last successful login in a mysql database and calculate how long the user has been using a site. how do i do this?Store date either in seconds since 19700101 or use your rdbms' datefield (most of them've got one). (I always prefer seconds as it's IMHO the easier to do calculations with) -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then.