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
- 3283 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the difference between now and current_date in mysql?
How to control the max size of a heap table?
write a c++ program to add a user to mysql.the user should be permitted to only "insert" into the given database
How to upload a large file through phpmyadmin in mysql?
How to write query to select word java's from column employees and from emp table
What does schema mean?
What is delimiter in mysql trigger?
How to insert dynamic values in mysql using php?
What is the function of myisamchk?
How would you enter characters as hex numbers?
How we can get the current date in mysql?
How to change a password for an existing user via mysqladmin?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
