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
- 2951 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 is a longblob?
What are the different column comparison operators in mysql?
Who developed mysql?
What is dblink?
How to get a list of indexes of an existing table?
How is myisam table stored?
How do I view a mysql database?
What is the purpose of using timestamp data type?
How does mysql encrypt passwords?
What is mysql database extension?
What are the different tables present in MySQL?
What are the 3 main types of search queries?
What do I do if I forgot my mysql root password?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What is procedures in mysql?
