[thelist] date time calculation query

[Hassan Schroeder]

On Tue, Sep 20, 2011 at 2:58 PM, Bob Meetin <bobm at dottedi.biz> wrote:
> I am writing a query against an existing database/table in which I need to
> qualify whether the member's subscription is active. Typically when I write
> these types of queries the 2 dates are in some date type, but here they are
> int(11) and I presume that the number is relevant to some date from point in
> time, but of course I'm unfamiliar with this method of doing calculations.
>
> The values:
>
> +----+---------+---------------+------------------+----------------+
> | id | user_id | membership_id | membership_start | membership_end |
> +----+---------+---------------+------------------+----------------+
> |  1 |      62 |             2 |       1316571958 |     1319163958 |
> |  2 |      62 |             1 |       1316572508 |     1319164508 |
> +----+---------+---------------+------------------+----------------+

Presuming MySQL --

mysql> select from_unixtime(1316571958);
+---------------------------+
| from_unixtime(1316571958) |
+---------------------------+
| 2011-09-20 19:25:58       |
+---------------------------+

mysql> select from_unixtime(1316571958, '%Y');
+---------------------------------+
| from_unixtime(1316571958, '%Y') |
+---------------------------------+
| 2011                            |
+---------------------------------+

Not sure why someone would choose that format over a standard
date or datetime, but...

HTH!
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com
http://about.me/hassanschroeder
twitter: @hassan