How to get current date & time in MySQL?

by

You can use NOW():

INSERT INTO servers (server_name, online_status, exchange, disk_space, network_shares, c_time)
VALUES('m1', 'ONLINE', 'exchange', 'disk_space', 'network_shares', NOW())

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Error in MySQL when setting default value for DATE or DATETIME
  3. Difference between two dates in MySQL
  4. MySQL Query to select data from last week?
  5. Datetime equal or greater than today in MySQL
  6. How to convert number of week into date?
  7. Set NOW() as Default Value for datetime datatype?
  8. Group mysql query by 15 min intervals
  9. SQL Query to show nearest date?
  10. how to cast the hexadecimal to varchar(datetime)?
  11. Get total hours worked in a day mysql
  12. MySQL: Insert datetime into other datetime field
  13. If two columns are 1 then make new column
  14. How can I return pivot table output in MySQL?
  15. Retrieving the last record in each group – MySQL
  16. Cast from VARCHAR to INT – MySQL
  17. Required to join 2 tables with their FKs in a 3rd table
  18. Does COUNT(*) always return a result?
  19. Connect By Prior Equivalent for MySQL
  20. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  21. How to convert all tables from MyISAM into InnoDB?
  22. How to create relationships in MySQL
  23. Mysql Improve Search Performance with wildcards (%%)
  24. ALTER TABLE to add a composite primary key
  25. Set value to NULL in MySQL
  26. MySql Single Table, Select last 7 days and include empty rows
  27. mysql SQL: specific item to be first and then to sort the rest of the items
  28. When is a timestamp (auto) updated?
  29. MySQL: Computed Column
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment