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
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.