*** 4. FormatDateTime – Full Example ***
FormatDateTime Example Output Screenshot
Step 1: Click on Visual Basic to Cut-n-paste code into FormatDateTime.aspx.vb
Partial Class _FormatDateTime
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'****************************************************************************************
' Purpose: Returns a string representing the datetime.
'
' Syntax: String.Format(datetime, formatspecifier)
'
' Parameter1: datetime - Required - datetime value to be formatted
'
' Parameter2: formatspecifier - required - format to be applied to date.
' Here are custom format specifiers y (year), M (month), d (day),
' h (hour 12), H (hour 24), m (minute), s (second),
' f (second fraction), F (second fraction, trailing zeroes are trimmed),
' t (P.M or A.M) and z (time zone).
'
' Result: string - Returns a string reperesenting the datetime.
'
' Quick Example: Dim dt As New DateTime(2009, 12, 20, 20, 4, 8, _
' 101)
' ' Ways to format year: "9 09 009 2009" year
' TextBox1.Text = String.Format("{0:y yy yyy yyyy}", dt)
' ' returns 9 09 009 2009
'
'**************************************************
' Custom DateTime Formatting
'**************************************************
Dim sb As New StringBuilder
sb.Append("Custom DateTime Formatting:<br />")
'Here are custom format specifiers y (year), M (month), d (day), h (hour 12), H (hour 24), m (minute), s (second),
' f (second fraction), F (second fraction, trailing zeroes are trimmed), t (P.M or A.M) and z (time zone).
'Following examples show how the format specifiers can be used.
' create date time 2009-12-21 20:04:08.101
Dim dt As New DateTime(2009, 12, 20, 20, 4, 8, _
101)
' Ways to format year: "9 09 009 2009" year
sb.Append(String.Format("{0:y yy yyy yyyy}", dt) + "<br />")
' Ways to format month: "12 12 Dec December" month
sb.Append(String.Format("{0:M MM MMM MMMM}", dt) + "<br />")
' Ways to format day: "21 21 Sun Sunday" day
sb.Append(String.Format("{0:d dd ddd dddd}", dt) + "<br />")
' Ways to format hour: "8 08 20 20" hour 12/24
sb.Append(String.Format("{0:h hh H HH}", dt) + "<br />")
' Ways to format minute: "4 04" minute
sb.Append(String.Format("{0:m mm}", dt) + "<br />")
' Ways to format second: ' "8 08" second
sb.Append(String.Format("{0:s ss}", dt) + "<br />")
' Ways to format fraction of second: "1 10 101 1010" sec.fraction
sb.Append(String.Format("{0:f ff fff ffff}", dt) + "<br />")
' Ways to format fraction of second: "1 1 101 101" without zeros
sb.Append(String.Format("{0:F FF FFF FFFF}", dt) + "<br />")
' How to display am or pm: "P PM" A.M. or P.M.
sb.Append(String.Format("{0:t tt}", dt) + "<br />")
' How to display timezone: "-6 -06 -06:00" time zone
sb.Append(String.Format("{0:z zz zzz}", dt) + "<br />")
'**************************************************
' Using date separator / (slash) and time sepatator : (colon).
'**************************************************
sb.Append("<br />")
sb.Append("Using date separator / (slash) and time sepatator : (colon):<br />")
'These characters will be rewritten to characters defined
'in the current DateTimeFormatInfo.DateSeparator and DateTimeFormatInfo.TimeSeparator.
' "20/12/09 20:04:08" - english (en-US)
sb.Append(String.Format("{0:d/M/yyyy HH:mm:ss}", dt) + "<br />")
' "20.12.2009 20:04:08" - german (de-DE)
' date separator in german culture is "." (so "/" changes to ".")
sb.Append(String.Format("{0:d/M/yyyy HH:mm:ss}", dt) + "<br />")
'**************************************************
' Here are some examples of custom date and time formatting:
'**************************************************
sb.Append("<br />")
sb.Append("Here are some examples of custom date and time formatting:<br />")
' month/day numbers without/with leading zeroes
' "12/20/2009"
sb.Append(String.Format("{0:M/d/yyyy}", dt) + "<br />")
' "12/20/2009"
sb.Append(String.Format("{0:MM/dd/yyyy}", dt) + "<br />")
' day/month names
' "Sun, Dec 20, 2009"
sb.Append(String.Format("{0:ddd, MMM d, yyyy}", dt) + "<br />")
' "Sunday, December 20, 2009"
' two/four digit year
sb.Append(String.Format("{0:dddd, MMMM d, yyyy}", dt) + "<br />")
' "12/20/09"
sb.Append(String.Format("{0:MM/dd/yy}", dt) + "<br />")
' "12/20/2009"
sb.Append(String.Format("{0:MM/dd/yyyy}", dt) + "<br />")
'**************************************************
' Standard DateTime Formatting
'**************************************************
sb.Append("<br />")
sb.Append("Standard DateTime Formatting:<br />")
'In DateTimeFormatInfo there are defined standard patterns for the current culture.
'For example, property ShortTimePattern is string that contains value h:mm tt for en-US culture
'and value HH:mm for de-DE culture.
'Following table shows patterns defined in DateTimeFormatInfo and their values for en-US culture.
'First column contains format specifiers for the String.Format method.
'Specifier DateTimeFormatInfo property Pattern value (for en-US culture)
't ShortTimePattern h:mm tt
'd ShortDatePattern M/d/yyyy
'T LongTimePattern h:mm:ss tt
'D LongDatePattern dddd, MMMM dd, yyyy
'f (combination of D and t) dddd, MMMM dd, yyyy h:mm tt
'F FullDateTimePattern dddd, MMMM dd, yyyy h:mm:ss tt
'g (combination of d and t) M/d/yyyy h:mm tt
'G (combination of d and T) M/d/yyyy h:mm:ss tt
'm, M MonthDayPattern MMMM dd
'y, Y YearMonthPattern MMMM, yyyy
'r, R RFC1123Pattern ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (*)
's SortableDateTimePattern yyyy'-'MM'-'dd'T'HH':'mm':'ss (*)
'u UniversalSortableDateTimePattern yyyy'-'MM'-'dd HH':'mm':'ss'Z' (*)
' (*) = culture independent
'Following examples show usage of standard format specifiers in String.Format method and the resulting output.
' "8:04 PM" ShortTime
sb.Append(String.Format("{0:t}", dt) + "<br />")
' "12/20/2009" ShortDate
sb.Append(String.Format("{0:d}", dt) + "<br />")
' "8:04:08 PM" LongTime
sb.Append(String.Format("{0:T}", dt) + "<br />")
' "Sunday, December 20, 2009" LongDate
sb.Append(String.Format("{0:D}", dt) + "<br />")
' "Sunday, December 20, 2009 8:04 PM" LongDate+ShortTime
sb.Append(String.Format("{0:f}", dt) + "<br />")
' "Sunday, December 20, 2009 8:04:08 PM" FullDateTime
sb.Append(String.Format("{0:F}", dt) + "<br />")
' "12/20/2009 8:04 PM" ShortDate+ShortTime
sb.Append(String.Format("{0:g}", dt) + "<br />")
' "12/20/2009 8:04:08 PM" ShortDate+LongTime
sb.Append(String.Format("{0:G}", dt) + "<br />")
' "December 20" MonthDay
sb.Append(String.Format("{0:m}", dt) + "<br />")
' "December, 2009" YearMonth
sb.Append(String.Format("{0:y}", dt) + "<br />")
' "Sun, 20 Dec 2009 20:04:08 GMT"
sb.Append(String.Format("{0:r}", dt) + "<br />")
' "2009-12-20T20:04:08" SortableDateTime
sb.Append(String.Format("{0:s}", dt) + "<br />")
' "2009-12-20 20:04:08Z" UniversalSortableDateTime
sb.Append(String.Format("{0:u}", dt) + "<br />")
Label1.Text = sb.ToString
End Sub
End Class |
Partial Class _FormatDateTime
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'****************************************************************************************
' Purpose: Returns a string representing the datetime.
'
' Syntax: String.Format(datetime, formatspecifier)
'
' Parameter1: datetime - Required - datetime value to be formatted
'
' Parameter2: formatspecifier - required - format to be applied to date.
' Here are custom format specifiers y (year), M (month), d (day),
' h (hour 12), H (hour 24), m (minute), s (second),
' f (second fraction), F (second fraction, trailing zeroes are trimmed),
' t (P.M or A.M) and z (time zone).
'
' Result: string - Returns a string reperesenting the datetime.
'
' Quick Example: Dim dt As New DateTime(2009, 12, 20, 20, 4, 8, _
' 101)
' ' Ways to format year: "9 09 009 2009" year
' TextBox1.Text = String.Format("{0:y yy yyy yyyy}", dt)
' ' returns 9 09 009 2009
'
'**************************************************
' Custom DateTime Formatting
'**************************************************
Dim sb As New StringBuilder
sb.Append("Custom DateTime Formatting:<br />")
'Here are custom format specifiers y (year), M (month), d (day), h (hour 12), H (hour 24), m (minute), s (second),
' f (second fraction), F (second fraction, trailing zeroes are trimmed), t (P.M or A.M) and z (time zone).
'Following examples show how the format specifiers can be used.
' create date time 2009-12-21 20:04:08.101
Dim dt As New DateTime(2009, 12, 20, 20, 4, 8, _
101)
' Ways to format year: "9 09 009 2009" year
sb.Append(String.Format("{0:y yy yyy yyyy}", dt) + "<br />")
' Ways to format month: "12 12 Dec December" month
sb.Append(String.Format("{0:M MM MMM MMMM}", dt) + "<br />")
' Ways to format day: "21 21 Sun Sunday" day
sb.Append(String.Format("{0:d dd ddd dddd}", dt) + "<br />")
' Ways to format hour: "8 08 20 20" hour 12/24
sb.Append(String.Format("{0:h hh H HH}", dt) + "<br />")
' Ways to format minute: "4 04" minute
sb.Append(String.Format("{0:m mm}", dt) + "<br />")
' Ways to format second: ' "8 08" second
sb.Append(String.Format("{0:s ss}", dt) + "<br />")
' Ways to format fraction of second: "1 10 101 1010" sec.fraction
sb.Append(String.Format("{0:f ff fff ffff}", dt) + "<br />")
' Ways to format fraction of second: "1 1 101 101" without zeros
sb.Append(String.Format("{0:F FF FFF FFFF}", dt) + "<br />")
' How to display am or pm: "P PM" A.M. or P.M.
sb.Append(String.Format("{0:t tt}", dt) + "<br />")
' How to display timezone: "-6 -06 -06:00" time zone
sb.Append(String.Format("{0:z zz zzz}", dt) + "<br />")
'**************************************************
' Using date separator / (slash) and time sepatator : (colon).
'**************************************************
sb.Append("<br />")
sb.Append("Using date separator / (slash) and time sepatator : (colon):<br />")
'These characters will be rewritten to characters defined
'in the current DateTimeFormatInfo.DateSeparator and DateTimeFormatInfo.TimeSeparator.
' "20/12/09 20:04:08" - english (en-US)
sb.Append(String.Format("{0:d/M/yyyy HH:mm:ss}", dt) + "<br />")
' "20.12.2009 20:04:08" - german (de-DE)
' date separator in german culture is "." (so "/" changes to ".")
sb.Append(String.Format("{0:d/M/yyyy HH:mm:ss}", dt) + "<br />")
'**************************************************
' Here are some examples of custom date and time formatting:
'**************************************************
sb.Append("<br />")
sb.Append("Here are some examples of custom date and time formatting:<br />")
' month/day numbers without/with leading zeroes
' "12/20/2009"
sb.Append(String.Format("{0:M/d/yyyy}", dt) + "<br />")
' "12/20/2009"
sb.Append(String.Format("{0:MM/dd/yyyy}", dt) + "<br />")
' day/month names
' "Sun, Dec 20, 2009"
sb.Append(String.Format("{0:ddd, MMM d, yyyy}", dt) + "<br />")
' "Sunday, December 20, 2009"
' two/four digit year
sb.Append(String.Format("{0:dddd, MMMM d, yyyy}", dt) + "<br />")
' "12/20/09"
sb.Append(String.Format("{0:MM/dd/yy}", dt) + "<br />")
' "12/20/2009"
sb.Append(String.Format("{0:MM/dd/yyyy}", dt) + "<br />")
'**************************************************
' Standard DateTime Formatting
'**************************************************
sb.Append("<br />")
sb.Append("Standard DateTime Formatting:<br />")
'In DateTimeFormatInfo there are defined standard patterns for the current culture.
'For example, property ShortTimePattern is string that contains value h:mm tt for en-US culture
'and value HH:mm for de-DE culture.
'Following table shows patterns defined in DateTimeFormatInfo and their values for en-US culture.
'First column contains format specifiers for the String.Format method.
'Specifier DateTimeFormatInfo property Pattern value (for en-US culture)
't ShortTimePattern h:mm tt
'd ShortDatePattern M/d/yyyy
'T LongTimePattern h:mm:ss tt
'D LongDatePattern dddd, MMMM dd, yyyy
'f (combination of D and t) dddd, MMMM dd, yyyy h:mm tt
'F FullDateTimePattern dddd, MMMM dd, yyyy h:mm:ss tt
'g (combination of d and t) M/d/yyyy h:mm tt
'G (combination of d and T) M/d/yyyy h:mm:ss tt
'm, M MonthDayPattern MMMM dd
'y, Y YearMonthPattern MMMM, yyyy
'r, R RFC1123Pattern ddd, dd MMM yyyy HH':'mm':'ss 'GMT' (*)
's SortableDateTimePattern yyyy'-'MM'-'dd'T'HH':'mm':'ss (*)
'u UniversalSortableDateTimePattern yyyy'-'MM'-'dd HH':'mm':'ss'Z' (*)
' (*) = culture independent
'Following examples show usage of standard format specifiers in String.Format method and the resulting output.
' "8:04 PM" ShortTime
sb.Append(String.Format("{0:t}", dt) + "<br />")
' "12/20/2009" ShortDate
sb.Append(String.Format("{0:d}", dt) + "<br />")
' "8:04:08 PM" LongTime
sb.Append(String.Format("{0:T}", dt) + "<br />")
' "Sunday, December 20, 2009" LongDate
sb.Append(String.Format("{0:D}", dt) + "<br />")
' "Sunday, December 20, 2009 8:04 PM" LongDate+ShortTime
sb.Append(String.Format("{0:f}", dt) + "<br />")
' "Sunday, December 20, 2009 8:04:08 PM" FullDateTime
sb.Append(String.Format("{0:F}", dt) + "<br />")
' "12/20/2009 8:04 PM" ShortDate+ShortTime
sb.Append(String.Format("{0:g}", dt) + "<br />")
' "12/20/2009 8:04:08 PM" ShortDate+LongTime
sb.Append(String.Format("{0:G}", dt) + "<br />")
' "December 20" MonthDay
sb.Append(String.Format("{0:m}", dt) + "<br />")
' "December, 2009" YearMonth
sb.Append(String.Format("{0:y}", dt) + "<br />")
' "Sun, 20 Dec 2009 20:04:08 GMT"
sb.Append(String.Format("{0:r}", dt) + "<br />")
' "2009-12-20T20:04:08" SortableDateTime
sb.Append(String.Format("{0:s}", dt) + "<br />")
' "2009-12-20 20:04:08Z" UniversalSortableDateTime
sb.Append(String.Format("{0:u}", dt) + "<br />")
Label1.Text = sb.ToString
End Sub
End Class
Step 2: Click on XML to Cut-n-paste code into FormatDateTime.aspx
< %@ Page Language="VB" AutoEventWireup="false" CodeFile="FormatDateTime.aspx.vb" Inherits="_FormatDateTime" %>
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1><asp:label ID="Label1" runat="server" Text="Label"></asp:label> </h1>
<asp:textbox ID="TextBox1" runat="server"></asp:textbox><br />
<h1><asp:label ID="Label2" runat="server" Text="Label"></asp:label> </h1>
<asp:textbox ID="TextBox2" runat="server"></asp:textbox><br />
<h1><asp:label ID="Label3" runat="server" Text="Label"></asp:label> </h1>
<asp:textbox ID="TextBox3" runat="server"></asp:textbox><br />
</div>
</form>
</body>
</html> |
< %@ Page Language="VB" AutoEventWireup="false" CodeFile="FormatDateTime.aspx.vb" Inherits="_FormatDateTime" %>
< !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1><asp:label ID="Label1" runat="server" Text="Label"></asp:label> </h1>
<asp:textbox ID="TextBox1" runat="server"></asp:textbox><br />
<h1><asp:label ID="Label2" runat="server" Text="Label"></asp:label> </h1>
<asp:textbox ID="TextBox2" runat="server"></asp:textbox><br />
<h1><asp:label ID="Label3" runat="server" Text="Label"></asp:label> </h1>
<asp:textbox ID="TextBox3" runat="server"></asp:textbox><br />
</div>
</form>
</body>
</html>
Prerequistes:
- Install Visual Web Developer 2010
- Install SQL Server Express
- Download Northwind and Pubs Databases
- Attach Northwind Database to Databases in Sql Express
- Attach pubs Database to Databases in Sql Express
Notes:
- You can build your own library of syntax examples by using same web site over and over and just add new web forms to it.
Instructions:
- Use Visual Web Developer 2010
- Create new web site;
- Click File/New Web Site
- Select ASP.NET Website Template
- Select Visual Basic for Language
- name of Web Site could be VBNET_ASPNET_Syntax.
- Add New folder named “StringManipulation”
- Right-click project name in solution explorer;
- add new folder;
- name of folder could be: StringManipulation
- Add Web Form Named FormatDateTime to StringManipulation folder
- Right-click StringManipulation folder;
- add new item;
- Select Web Form
- Check place code behind in separate file
- Web Form name could be FormatDateTime
- Click on Visual Basic in step 1 at the top of this page to copy code into code-behind FormatDateTime.aspx.vb
- Click on XML in step 2 above to copy code into web form FormatDateTime.aspx
- Right-click on FormatDateTime.aspx in solution explorer and select view in browser
|