you can get the date only a number of ways, my preference is to do: select (cast(convert(varchar(8),datecolumn,112) as smalldatetime) from tablename
this does the following: converts using format 112 = yyyyMMdd - has no time, only date then it casts to a datatime, so the time part will be 00:00:00. On 30 Sep, 10:18, "vanitha palanisamy" <[EMAIL PROTECTED]> wrote: > Hi > Am Vanitha, > > Can anyone say, > Is this possible to filter only date from datetime in datatable. > > or can say how to set the format of date in datatable. > > Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx <p><a href="http://feeds.feedburner.com/DotNetDevelopment";><img src="http://feeds.feedburner.com/~fc/DotNetDevelopment?bg=99CCFF&fg=444444&anim=1"; height="26" width="88" style="border:0" alt="" /></a></p> -~----------~----~----~----~------~----~------~--~---
