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
- 3197 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 datadir?
Can you tell few best practices to be followed for optimization in sql?
What is full text indexing in mysql?
Which is better sqlite or mysql?
How do I clear the screen in mysql?
What is mvcc in mysql?
What is the difference between unix timestamp and mysql timestamp?
What is mysql used for?
Restore database (or database table) from backup.
Explain csv tables.
What is mysqlcommand?
What is 'mysqld'?
What are the method you will follow while sql installing
What are the purposes of using enum and set data types?
Why is the basic difference between left join, right join and inner join?
