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
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
Can mysql function return a table?
What is the return type of mysqli_query?
What is a data directory?
What is the difference between char and varchar in mysql?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
Is there a way to see the files which are stored?
What is row level locking in access?
Can I use mariadb instead of mysql?
Why myisam is faster than innodb?
How to escape special characters in sql statements?
Does insert statement lock the table?
Is mysql owned by oracle?
What is the current version of mysql?
What is key in mysql?
Can we rollback truncate in mysql?