title: How to insert today's date in mysql query?
body: <p>I'm using PHP and MySQL. My sql query is as follows:</p>
  
  <pre><code>INSERT INTO ocn.newsletter
              (newsletter_name,
               newsletter_subject,
               newsletter_email_body,
               newsletter_call_to_action_status,
               newsletter_call_to_action_text,
               newsletter_call_to_action_link,
               newsletter_created_date)
  VALUE      ('Ramzan ID',
              'Ramzan Greetings',
              'Happy Ramzan Eid to All',
              '0',
              '',
              '',
              From_unixtime(Curdate()) )  
  </code></pre>
  
  <p>I want to store todays date in UNIX Timestamp format. If I execute above query I'm getting 1970 stored into the table. Actually I want to store UNIX timestamp equivalent of today's date. Can anyone help me in this regard? Thanks in  advance.</p>