Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting dates from SQL into C# DateTime objects
Message
From
16/07/2004 13:58:34
Keith Payne
Technical Marketing Solutions
Florida, United States
 
 
To
15/07/2004 19:47:42
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00924961
Message ID:
00925278
Views:
13
>I can't figure out how to convert datetime field from Microsoft SQL Server into a C# DateTime object. I have found the DateTime.Parse and DateTime.ParseExact methods, but can't really figure out IFormatProvider. Once I have the string from Microsoft SQL, I would expect that, since it was a commonly used format, there would be an easy way, I just can't find it.
>
>(I just want to dump the datum from the database into a DateTime object. I don't have to worry about formatting it's output now.)

David,

Do you mean that the field in your SQL Server table is varchar? If it is DateTime, the SQL ADO.NET provider performs the conversion automatically.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform