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
- 3216 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 are the functions in mysql?
What is a data directory?
How do I delete a row in mysql?
How we can see all indexes defined for a table in mysql?
How can you make a database as your current database?
How we can get distinct columns values in mysql?
What ascii 31?
What is strict mode in mysql?
How to enable or disable a row of a table using MySQL in struts?
What is the default port for MySQL Server?
What is pragma exception?
I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.
How does limit work in mysql?
What is 'mysqldump'?
What are date and time data types?
