Interested to Buy Any Domain ? << Click Here >> for more details...
How many ways we can we find the current date using MySQL?
- 3 Answers
- 8965 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikas d.k. gupta
To get the Current Date:-
1. SELECT CURDATE();
2. SELECT CURRENT_DATE();
To get the Current Time:-
1. SELECT CURTIME();
2. SELECT CURRENT_TIME();
To get both at the same time:-
1. SELECT NOW();
2. SELECT SYSDATE();
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
can you tell the order of sql select statement? : Mysql dba
Can we write pl sql mysql?
What is information_schema in mysql?
What is the difference between float and double?
Does adding an index lock a table?
How do I restart mysql on windows?
What is identity in mysql?
How to drop an existing table in mysql?
What is mysql enterprise edition?
Why should I learn mysql?
What is int mysql?
What is flush privileges in mysql?
How do I start mysql in linux?
What are the differences between char and varchar data types?
How many rows can mysql hold?
