Your whole approach is wrong. Date/time is the universal notion and does not really have any different formats. The formats come into play if you try to store data in the form of strings. You should not. When it comes to databases, store this time data using DATE datatype, which actually represent a point in time, not just date (so the name of type is confusing). And you will need strings only if you want to present date/time on screen, but then you can use appropriate formatting:
http://msdn.microsoft.com/en-us/library/zdtaw1bw.aspx[
^],
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx[
^],
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[
^].
(See also all other
System.DateTime.ToString/Parse/TryParse/ParseExact/TryParseExact
methods.)
Generally, the trend to work with string representing data instead of data itself is a very common beginner's problem these days. Don't repeat this mistake, try to work with data.
—SA