From: | Steve Leibel <stevel(at)bluetuna(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | timestamp calculations |
Date: | 2001-01-25 23:14:58 |
Message-ID: | v04210122b69663a58cdd@[24.168.80.161] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers |
Hello,
I'm converting a mysql db to postgres and ran into this line of code:
$SQL = "select username from users where user_id = ? AND session = ?
AND ADDDATE(last_login, INTERVAL 30 MINUTE)>CURRENT_TIMESTAMP()
How do I implement adddate to get this kind of funcionality?
Thanks,
Steve Leibel
From | Date | Subject | |
---|---|---|---|
Next Message | Ramiro Arenas Ramírez | 2001-01-25 23:26:19 | where are The logs? |
Previous Message | lbottorff | 2001-01-25 22:55:05 | pg_shadow prob solved |
From | Date | Subject | |
---|---|---|---|
Next Message | eriko | 2001-01-25 23:56:37 | Problem with index |
Previous Message | Stephan Szabo | 2001-01-25 23:14:53 | Re: The type int8 and the use of indexes |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-01-26 00:05:56 | Re: timestamp calculations |
Previous Message | Oliver Elphick | 2001-01-25 22:47:03 | Re: RPM: Contrib request. |