I am using SQL server and running a sql SELECT query. The date column is displaying date and time. I need to get rid of the time part. I have tried convert function, casting etc.. but none seems to work. Any help on this will be greatly appreciated.
Thanks.
Renu

In what type of control are you displaying the datetime? You can use String.Format or some formatting string in most controls to specify what format of the date you would like.

Thanks for such a quick response. I am using a textbox. Should any other control be used? The format needed is "mm-dd-yyyy".

Take a look at DateTime formatting:

http://msdn.microsoft.com/library/de...matstrings.asp

I believe the link you sent can be used to write a function and get the date in the required format. I am sure there must be a function that can directly be used in the SELECT command.

This is very strange. I ran the following statement in the query analyser on sql server and it ran fine... If gives me the date in the format I want.

select convert(char(10,workdate,101) from tbl_jurisdiction

But, when I use the same convert function in the select command generated by VS.NET, I get blank date!! Any comments on this will be highly appreciated.
Thanks in advance.
Renu

this is probably because you are trying to extract a specific field in your .NET code. when you do that function in SQL, you have to re-assign the fieldname as the alias of the output so that .NET can get at the value:

select convert(char(10,workdate,101) AS workdate from tbl_jurisdiction

(By the way, there are several SQL language forums on here that might yield you better results for SQL specific questions.)

I tried with ....AS workdate....
but still it doesn't work. I am going to check in SQL forum as suggested by you. In the meanwhile, if anybody knows answer to this question, please post it here. Thanks
Renu

Hi Renu,

There seems to be bracket missing in your code. Was that really missing? Can you check, if that helps?

_________________________
- Vijay G
Strive for Perfection

Ya, that was just a typo. The bracket was there.
Let's resume it here at this thread. I just went to SQL forum hoping that I would get some answer.