String to Date or String to DateTime in Visual Basic

Dim myString As String = "2010-09-01 21:34 PM";
'myString = "1999-09-01 21:34 p.m.";  //Depends on your regional settings

'first example
Dim myDateTime As DateTime
myDateTime = DateTime.ParseExact(MyString, "yyyy-MM-dd HH:mm tt", Nothing)

'second example
' ATTENTION / has to be escaped via \/
Dim test As String = "10/11/2010 18:56:02"
myDateTime = DateTime.ParseExact(test, "MM\/dd\/yyyy HH:mm:ss", Nothing)


'Formats
'd - Numeric day of the month without a leading zero.
'dd - Numeric day of the month with a leading zero.
'ddd - Abbreviated name of the day of the week.
'dddd - Full name of the day of the week.

'f,ff,fff,ffff,fffff,ffffff,fffffff - 
'  Fraction of a second. The more Fs the higher the precision.

'h - 12 Hour clock, no leading zero.
'hh - 12 Hour clock with leading zero.
'H - 24 Hour clock, no leading zero.
'HH - 24 Hour clock with leading zero.

'm - Minutes with no leading zero.
'mm - Minutes with leading zero.

'M - Numeric month with no leading zero.
'MM - Numeric month with a leading zero.
'MMM - Abbreviated name of month.
'MMMM - Full month name.

's - Seconds with no leading zero.
'ss - Seconds with leading zero.

't - AM/PM but only the first letter. 
'tt - AM/PM ( a.m. / p.m.)

'y - Year with out century and leading zero.
'yy - Year with out century, with leading zero.
'yyyy - Year with century.

'zz - Time zone off set with +/-.

Comments