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
- 3344 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 |
How do you rename a table?
What does mysql flush privileges do?
How to get full name of monthname ?
What is row level locking in access?
What is the use of i-am-a-dummy flag in mysql?
What are the functions of mysql?
Write a program using the select statement, while loop.
Are stored procedures precompiled?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What is the purpose of using ifnull() function?
How do I change global variables in mysql?
How do I know if mysql is running on windows?
-
Oracle (3253) - 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)
