how to compare between mysql datetime field and current date time ?

Discussion in 'PHP' started by ramysarwat, Nov 10, 2009.

  1. #1
    how to compare between mysql datetime field and current date time ?
     
    ramysarwat, Nov 10, 2009 IP
  2. javaongsan

    javaongsan Well-Known Member

    Messages:
    1,054
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    128
    #2
    something like DATE(mysql_date) >= DATE(CURDATE())
     
    javaongsan, Nov 11, 2009 IP
  3. AsHinE

    AsHinE Well-Known Member

    Messages:
    240
    Likes Received:
    8
    Best Answers:
    1
    Trophy Points:
    138
    #3
    Or if you need time too
    
    date_field >= NOW()
    
    Code (markup):
     
    AsHinE, Nov 11, 2009 IP