title: Convert Mysql Date (NOW()) to bigint
body: <p>i have a mysql trigger that updates a table when there's an insert in another table. My question is this, how can i convert the current date to bigint value, because it's the bigint value that needs to be updated. This is the update statement</p>
  
  <p>UPDATE clocks SET last_clock_upload = NOW() WHERE clock_id = NEW.clock_id</p>
  
  <p>How can i change the NOW() to bigint?</p>