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 DATETIMERobert Canary8 Oct
  • Re: de-Incrementing DATETIMEThimble Smith8 Oct
  • Re: de-Incrementing DATETIMEDerek Lavine8 Oct
  • Re: de-Incrementing DATETIMEBob Kline8 Oct
    • Re: de-Incrementing DATETIMERobert Canary8 Oct
      • Re: de-Incrementing DATETIMEBob Kline8 Oct
        • Re: de-Incrementing DATETIMERobert Canary8 Oct