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
- 3347 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
Explain what is mysql?
Why do we use group by and order by function in mysql?
How to install mysql?
What does mysql flush hosts do?
Is oracle better than mysql?
What is foreign key in mysql?
Can we write procedure in mysql?
How do you backup a database in mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
How to get help information from the server?
What is innodb mysql?
What is pdo in php mysql?
Which command is used to view the content of the table in mysql?
What is the difference between truncate and delete?
What command is used to delete the data from the table without deleting the table structure?
