Click here to Skip to main content
15,887,361 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionAutoClose of DivisionTag Window ....... Pin
priyareguri30-Mar-10 18:58
priyareguri30-Mar-10 18:58 
AnswerRe: AutoClose of DivisionTag Window ....... Pin
Sandeep Mewara30-Mar-10 20:16
mveSandeep Mewara30-Mar-10 20:16 
AnswerRe: AutoClose of DivisionTag Window ....... Pin
Arindam Tewary30-Mar-10 21:11
professionalArindam Tewary30-Mar-10 21:11 
Questionhow to databind a adrotator [modified] Pin
ships_agr30-Mar-10 18:33
ships_agr30-Mar-10 18:33 
Questionproblem with datetime datatype of sqlserver 2005 using asp.net Pin
ships_agr30-Mar-10 18:30
ships_agr30-Mar-10 18:30 
AnswerRe: problem with datetime datatype of sqlserver 2005 using asp.net Pin
test-0930-Mar-10 18:49
test-0930-Mar-10 18:49 
AnswerRe: problem with datetime datatype of sqlserver 2005 using asp.net Pin
Arindam Tewary30-Mar-10 19:25
professionalArindam Tewary30-Mar-10 19:25 
AnswerRe: problem with datetime datatype of sqlserver 2005 using asp.net Pin
Dinesh Mani30-Mar-10 20:16
Dinesh Mani30-Mar-10 20:16 
As others have pointed out, you have no way to store only the date part in date time field. You have to store only datetime or store the date in a string field. Doing the later would hinder you if you wish to do data manipulation based on the date value.

Now if you try to store only the date in a datetime column, the db by default would add 00 hrs as the default time value [correct me if I'm wrong].

Now you can easily remove the time part in the query using CONVERT(VARCHAR,[date column],101). But doing so would put extra load on your query and reduce its performance.

The best way to deal with it is to get the datetime value to the application and apply formatters to remove the time part from the datetime value. All that you need to do is to set the format string for the control that is going to display the value and you would be done.

HTH!
GeneralRe: problem with datetime datatype of sqlserver 2005 using asp.net Pin
ships_agr31-Mar-10 3:50
ships_agr31-Mar-10 3:50 
Questionrepeater control Pin
test-0930-Mar-10 18:26
test-0930-Mar-10 18:26 
AnswerRe: repeater control Pin
Arun Jacob30-Mar-10 20:02
Arun Jacob30-Mar-10 20:02 
GeneralRe: repeater control Pin
test-0930-Mar-10 20:10
test-0930-Mar-10 20:10 
AnswerRe: repeater control Pin
Arun Jacob30-Mar-10 20:12
Arun Jacob30-Mar-10 20:12 
GeneralRe: repeater control Pin
test-0930-Mar-10 20:19
test-0930-Mar-10 20:19 
AnswerRe: repeater control Pin
Arun Jacob30-Mar-10 20:23
Arun Jacob30-Mar-10 20:23 
GeneralRe: repeater control Pin
test-0930-Mar-10 20:46
test-0930-Mar-10 20:46 
AnswerRe: repeater control Pin
Arun Jacob30-Mar-10 20:53
Arun Jacob30-Mar-10 20:53 
GeneralRe: repeater control Pin
test-0930-Mar-10 21:03
test-0930-Mar-10 21:03 
GeneralRe: repeater control Pin
Arindam Tewary30-Mar-10 21:15
professionalArindam Tewary30-Mar-10 21:15 
Questionusing javascript to create seat chart Pin
ships_agr30-Mar-10 18:15
ships_agr30-Mar-10 18:15 
AnswerRe: using javascript to create seat chart Pin
sashidhar30-Mar-10 23:34
sashidhar30-Mar-10 23:34 
GeneralRe: using javascript to create seat chart [modified] Pin
ships_agr31-Mar-10 3:48
ships_agr31-Mar-10 3:48 
GeneralRe: using javascript to create seat chart Pin
sashidhar31-Mar-10 19:39
sashidhar31-Mar-10 19:39 
GeneralRe: using javascript to create seat chart Pin
ships_agr1-Apr-10 3:32
ships_agr1-Apr-10 3:32 
GeneralRe: using javascript to create seat chart(i tried nd presenting the code here) Pin
ships_agr1-Apr-10 5:21
ships_agr1-Apr-10 5:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.