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
madhurimonica
0
Newbie Poster
Recommended Answers
Jump to PostCould you please post your code and tell, which DB you're using.
Jump to PostUse
create table sample ( testdate datetime )
All 5 Replies
Teme64
215
Veteran Poster
Could you please post your code and tell, which DB you're using.
madhurimonica
0
Newbie Poster
i am using sql server
i just tried 2 create table with field of datatype date
create table mrf(fr date);
kvprajapati
1,826
Posting Genius
Team Colleague
Use
create table sample
(
testdate datetime
)
madhurimonica
0
Newbie Poster
thnks.
kvprajapati
1,826
Posting Genius
Team Colleague
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.