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

    Current date in mysql curdate()

    8th October 2013

    MySql

    mysql codehaven category

    This will produce 2013-10-29

    1
    2
    3
    4
     
    SELECT NOW(); // You will get 2010-12-09 17:10:18
    SELECT CURDATE(); // You will get 2010-12-09
     

    Another example is

    1
    2
    3
     
    $query = "INSERT INTO table1 (date, time, operator, status, completed, name, email) VALUES (CURDATE(), CURTIME(), '".$operator."', '".$status."', '".$complete."', '".$name."', '".$email."')";
     

    Tomorrows date

    1
    2
    3
     
    SELECT CURDATE()+1;
     

    And some more interesting ways…

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
     
    select curdate();
    -- 2011-01-31
     
    select cast(curdate() as datetime);
    -- 2011-01-31 00:00:00
     
    select if('2011-01-31' <= curdate(), 'yep', 'not this time');
    -- yep
     
    select if('2011-01-31 00:00:01' <= curdate(), 'yep', 'not this time');
    -- not this time
     
    select if('2011-01-31 01:00:00' <= adddate(curdate(), interval 1 day), 'yep', 'not this time');
    -- yep
     


    And another

    1
    2
    3
     
    $result = mysql_query("SELECT * FROM cmdata WHERE date=curdate() and time=DATE_FORMAT(NOW(),'%H')");
     

    More info here about other formats like hour etc

    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