Interested to Buy Any Domain ? << Click Here >> for more details...
when i declare date data type in sql ,i inserted the date
22-10-2012,but my result is in different date 1894-07-11 any
one pls help me what's wrong in my query
Create table orders(od_id int,od_name varchar(10),od_date
date)
insert into orders values(1,'sai',22-10-2012) and any one
pls suggest what i can learn for 3 years real time
experenice in sql because i am looking for database field
- 1 Answers
- 3279 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi
The default date format in sql is 'yyyy-mm-dd' but in the query that is in dd-mm-yyyy and without single quotes. Below is the insert query.
insert into orders values(1,'sai','2012-10-22');
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What storage engines are used in MySQL?
what is the difference between between and in operators in mysql?
What is mysql database extension?
What are procedures in mysql? Explain
What is ndb in mysql?
How do I view tables in mysql workbench?
How do I find mysql database?
What is the size of mysql database?
How can you filter the duplicate data while retrieving records from the table?
Where is mysql installed on linux?
Why do we use pragma autonomous transaction?
Does mysql need a server?
How do you create a schema?
How to create and drop view in mysql?
Can we store pdf files in mysql?
