In my App,some date based computations are there,so for practice purpose I tried the following example.
I created Table,that corresponding code is in following below.
CREATE TABLE DateFormatTesting( date Date,Name varchar(100))
I inserted some values into that table,That corresponding code is in below
insert into DateFormatTesting (DateFormatTesting.date,DateFormatTesting.Name) values ('1990-12-21','Subbu')
If you can observe the above query,my Date structure is like YYYY-MM-DD,I evaluated above query,it returns 1 row affected.
again,I try toinsert different structure of the Date ,but it's not working.That corresponding code is in following below.
insert into DateFormatTesting (DateFormatTesting.date,DateFormatTesting.Name) values ('21-12-1990','Subbu')
How can I change Date structure.and also where will I get good documentations for Date with Examples.