when i declare date data type in sql ,i inserted the date 22-10-2012,but my re

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

Question Posted / ssp

1 Answers
2675 Views
I also Faced
E-Mail Answers

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different..

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

Post New Answer