| 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. |