codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    MySQL DATE_SUB Function – Date minus time

    2nd June 2014

    MySql

    mysql codehaven category

    Assume we have the following Orders

    OrderId: 1
    ProductName : OrderDate1
    Cheese: 2008-11-11 13:23:44
    Now we want to subtract 5 days from the OrderDate date.We use the following SELECT statement:

    1
    2
    3
     
    SELECT OrderId,DATE_SUBOrderDate,INTERVAL 5 DAY AS SubtractDateFROM Orders
     

    Result: 2008-11-06 13:23:44

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN