How to get the date part of DateTime

[ad]

I use a string sDate to fetch a SmallDateTime field form SQL Server
and the result is :"2005/12/12 ¤W¤È 12:00:00";

How can I get the Date part from the string?
or can I get the Date part from database?

 

[Dries De Rudder]

maybe you can use a System.DateTime to fetch the SmallDateTime field
from SQL Server en then use dateTime.ToShortDateString() to get a string
with just the Date part

greetz,
Dries

ad schreef:

 

[Mark Rae]

I use a string sDate to fetch a SmallDateTime field form SQL Server
and the result is :"2005/12/12 ¤W¤È 12:00:00";

How can I get the Date part from the string?
or can I get the Date part from database?

sDate = <ADO.NET object>["sDate"].ToString("dd MMM yyyy");

 

[Alvin Bruney [MVP - ASP.NET]]

either that or you can parse the string from the database into a valid date
time object using the static parse method.

--
Regards,
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc, Amazon, B&H etc


Forth-coming VSTO.NET
-------------------------------------------------------------------------------

I use a string sDate to fetch a SmallDateTime field form SQL Server
and the result is :"2005/12/12 ¤W¤È 12:00:00";

How can I get the Date part from the string?
or can I get the Date part from database?

sDate = <ADO.NET object>["sDate"].ToString("dd MMM yyyy");