hi, i am using this datetime data type in one of my mssql tables...
i just want date & not time........ can any one help me with a patch of code.......
thanks in advance
gani
0
Newbie Poster
Recommended Answers
Jump to Postselect convert(mydatecolumn,varchar(15),101)
All 2 Replies
itsdavetime
0
Newbie Poster
select convert(mydatecolumn,varchar(15),101)
Nilesh Warude
0
Newbie Poster
i 'll enter date through date through text,month through dropdownlist and year through text but when insert in database then time also inserted so how we'll spilt time from date
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.