| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Thimble Smith | Date: | October 8 1999 12:56am |
| Subject: | Re: de-Incrementing DATETIME | ||
| View as plain text | |||
At 19:53, 19991007, Robert Canary wrote:
>Dose anyone know how to de-inc a datetime field?
Untested:
mysql> update table set date_field = date_sub(date_field, interval 1 day);
Tim
| Thread | ||
|---|---|---|
| • de-Incrementing DATETIME | Robert Canary | 8 Oct |
| • Re: de-Incrementing DATETIME | Thimble Smith | 8 Oct |
| • Re: de-Incrementing DATETIME | Derek Lavine | 8 Oct |
| • Re: de-Incrementing DATETIME | Bob Kline | 8 Oct |
| • Re: de-Incrementing DATETIME | Robert Canary | 8 Oct |
| • Re: de-Incrementing DATETIME | Bob Kline | 8 Oct |
| • Re: de-Incrementing DATETIME | Robert Canary | 8 Oct |