how to create a table using date data type
i am getting error during creating table
create table mrf(fr date);


error: cannot find data type date

Could you please post your code and tell, which DB you're using.

i am using sql server
i just tried 2 create table with field of datatype date
create table mrf(fr date);

Use

create table sample 
(
    testdate datetime
)

You have opened too many threads.

Mark the thread as Solved if you get solution.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.