How to get Current Date and Time in MySQL?
Related FAQs
- how to find which tables use innodb in mysql
- How to search a tablename in schema
- How to get the students who are in more than one group mysql
- How to find the duplicate rows by comparing two columns in a table mysql
- How to get the length of a string in a column mysql
- How to get the records posted in this month in mysql
- how to find duplicate rows in a table based on specific column
- how to determine constant values in mysql
- how to concatenate all rows of a particular column in a table mysql
- How to connect the mysql from command prompt
we can get the datetime
Fri, 06/20/2008 - 19:17 — adminwe can get the datetime using mysql function now()
mysql> SELECT NOW();
o/p : 2005-08-4 19:40:00