Skip to main content

ASP.NET DATE FORMAT CUSTOME

string SSS = DateTime.Now.ToString("dddd, d MMMM, yyyy", CultureInfo.CreateSpecificCulture("en-US"));

DateTime date1 = new DateTime(2008, 8, 29, 19, 27, 15);

Console.WriteLine(date1.ToString("ddd d MMM", 
                  CultureInfo.CreateSpecificCulture("en-US")));
// Displays Fri 29 Aug
Console.WriteLine(date1.ToString("ddd d MMM", 
                  CultureInfo.CreateSpecificCulture("fr-FR")));
// Displays ven. 29 août 
 
 
DateTime date1 = new DateTime(2008, 8, 29, 19, 27, 15, 18);
CultureInfo ci = CultureInfo.InvariantCulture;

Console.WriteLine(date1.ToString("hh:mm:ss.f", ci));
// Displays 07:27:15.0
Console.WriteLine(date1.ToString("hh:mm:ss.F", ci));
// Displays 07:27:15
Console.WriteLine(date1.ToString("hh:mm:ss.ff", ci));
// Displays 07:27:15.01
Console.WriteLine(date1.ToString("hh:mm:ss.FF", ci));
// Displays 07:27:15.01
Console.WriteLine(date1.ToString("hh:mm:ss.fff", ci));
// Displays 07:27:15.018
Console.WriteLine(date1.ToString("hh:mm:ss.FFF", ci));
// Displays 07:27:15.018
 
 
Format specifier
 Description
 Examples
"d"
 The day of the month, from 1 through 31.
More information: The "d" Custom Format Specifier.
 6/1/2009 1:45:30 PM -> 1
6/15/2009 1:45:30 PM -> 15
"dd"
 The day of the month, from 01 through 31.
More information: The "dd" Custom Format Specifier.
 6/1/2009 1:45:30 PM -> 01
6/15/2009 1:45:30 PM -> 15
"ddd"
 The abbreviated name of the day of the week.
More information: The "ddd" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> Mon (en-US)
6/15/2009 1:45:30 PM -> Пн (ru-RU)
6/15/2009 1:45:30 PM -> lun. (fr-FR)
"dddd"
 The full name of the day of the week.
More information: The "dddd" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> Monday (en-US)
6/15/2009 1:45:30 PM -> понедельник (ru-RU)
6/15/2009 1:45:30 PM -> lundi (fr-FR)
"f"
 The tenths of a second in a date and time value.
More information: The "f" Custom Format Specifier.
 6/15/2009 13:45:30.617 -> 6
6/15/2009 13:45:30.050 -> 0
"ff"
 The hundredths of a second in a date and time value.
More information: The "ff" Custom Format Specifier.
 6/15/2009 13:45:30.617 -> 61
6/15/2009 13:45:30.005 -> 00
"fff"
 The milliseconds in a date and time value.
More information: The "fff" Custom Format Specifier.
 6/15/2009 13:45:30.617 -> 617
6/15/2009 13:45:30.0005 -> 000
"ffff"
 The ten thousandths of a second in a date and time value.
More information: The "ffff" Custom Format Specifier.
 6/15/2009 13:45:30.6175 -> 6175
6/15/2009 13:45:30.00005 -> 0000
"fffff"
 The hundred thousandths of a second in a date and time value.
More information: The "fffff" Custom Format Specifier.
 6/15/2009 13:45:30.61754 -> 61754
6/15/2009 13:45:30.000005 -> 00000
"ffffff"
 The millionths of a second in a date and time value.
More information: The "ffffff" Custom Format Specifier.
 6/15/2009 13:45:30.617542 -> 617542
6/15/2009 13:45:30.0000005 -> 000000
"fffffff"
 The ten millionths of a second in a date and time value.
More information: The "fffffff" Custom Format Specifier.
 6/15/2009 13:45:30.6175425 -> 6175425
6/15/2009 13:45:30.0001150 -> 0001150
"F"
 If non-zero, the tenths of a second in a date and time value.
More information: The "F" Custom Format Specifier.
 6/15/2009 13:45:30.617 -> 6
6/15/2009 13:45:30.050 -> (no output)
"FF"
 If non-zero, the hundredths of a second in a date and time value.
More information: The "FF" Custom Format Specifier.
 6/15/2009 13:45:30.617 -> 61
6/15/2009 13:45:30.005 -> (no output)
"FFF"
 If non-zero, the milliseconds in a date and time value.
More information: The "FFF" Custom Format Specifier.
 6/15/2009 13:45:30.617 -> 617
6/15/2009 13:45:30.0005 -> (no output)
"FFFF"
 If non-zero, the ten thousandths of a second in a date and time value.
More information: The "FFFF" Custom Format Specifier.
 6/1/2009 13:45:30.5275 -> 5275
6/15/2009 13:45:30.00005 -> (no output)
"FFFFF"
 If non-zero, the hundred thousandths of a second in a date and time value.
More information: The "FFFFF" Custom Format Specifier.
 6/15/2009 13:45:30.61754 -> 61754
6/15/2009 13:45:30.000005 -> (no output)
"FFFFFF"
 If non-zero, the millionths of a second in a date and time value.
More information: The "FFFFFF" Custom Format Specifier.
 6/15/2009 13:45:30.617542 -> 617542
6/15/2009 13:45:30.0000005 -> (no output)
"FFFFFFF"
 If non-zero, the ten millionths of a second in a date and time value.
More information: The "FFFFFFF" Custom Format Specifier.
 6/15/2009 13:45:30.6175425 -> 6175425
6/15/2009 13:45:30.0001150 -> 000115
"g", "gg"
 The period or era.
More information: The "g" or "gg" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> A.D.
"h"
 The hour, using a 12-hour clock from 1 to 12.
More information: The "h" Custom Format Specifier.
 6/15/2009 1:45:30 AM -> 1
6/15/2009 1:45:30 PM -> 1
"hh"
 The hour, using a 12-hour clock from 01 to 12.
More information: The "hh" Custom Format Specifier.
 6/15/2009 1:45:30 AM -> 01
6/15/2009 1:45:30 PM -> 01
"H"
 The hour, using a 24-hour clock from 0 to 23.
More information: The "H" Custom Format Specifier.
 6/15/2009 1:45:30 AM -> 1
6/15/2009 1:45:30 PM -> 13
"HH"
 The hour, using a 24-hour clock from 00 to 23.
More information: The "HH" Custom Format Specifier.
 6/15/2009 1:45:30 AM -> 01
6/15/2009 1:45:30 PM -> 13
"K"
 Time zone information.
More information: The "K" Custom Format Specifier.
 With DateTime values:
6/15/2009 1:45:30 PM, Kind Unspecified ->
6/15/2009 1:45:30 PM, Kind Utc -> Z
6/15/2009 1:45:30 PM, Kind Local -> -07:00 (depends on local computer settings)
With DateTimeOffset values:
6/15/2009 1:45:30 AM -07:00 --> -07:00
6/15/2009 8:45:30 AM +00:00 --> +00:00
"m"
 The minute, from 0 through 59.
More information: The "m" Custom Format Specifier.
 6/15/2009 1:09:30 AM -> 9
6/15/2009 1:09:30 PM -> 9
"mm"
 The minute, from 00 through 59.
More information: The "mm" Custom Format Specifier.
 6/15/2009 1:09:30 AM -> 09
6/15/2009 1:09:30 PM -> 09
"M"
 The month, from 1 through 12.
More information: The "M" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> 6
"MM"
 The month, from 01 through 12.
More information: The "MM" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> 06
"MMM"
 The abbreviated name of the month.
More information: The "MMM" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> Jun (en-US)
6/15/2009 1:45:30 PM -> juin (fr-FR)
6/15/2009 1:45:30 PM -> Jun (zu-ZA)
"MMMM"
 The full name of the month.
More information: The "MMMM" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> June (en-US)
6/15/2009 1:45:30 PM -> juni (da-DK)
6/15/2009 1:45:30 PM -> uJuni (zu-ZA)
"s"
 The second, from 0 through 59.
More information: The "s" Custom Format Specifier.
 6/15/2009 1:45:09 PM -> 9
"ss"
 The second, from 00 through 59.
More information: The "ss" Custom Format Specifier.
 6/15/2009 1:45:09 PM -> 09
"t"
 The first character of the AM/PM designator.
More information: The "t" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> P (en-US)
6/15/2009 1:45:30 PM -> 午 (ja-JP)
6/15/2009 1:45:30 PM -> (fr-FR)
"tt"
 The AM/PM designator.
More information: The "tt" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> PM (en-US)
6/15/2009 1:45:30 PM -> 午後 (ja-JP)
6/15/2009 1:45:30 PM -> (fr-FR)
"y"
 The year, from 0 to 99.
More information: The "y" Custom Format Specifier.
 1/1/0001 12:00:00 AM -> 1
1/1/0900 12:00:00 AM -> 0
1/1/1900 12:00:00 AM -> 0
6/15/2009 1:45:30 PM -> 9
"yy"
 The year, from 00 to 99.
More information: The "yy" Custom Format Specifier.
 1/1/0001 12:00:00 AM -> 01
1/1/0900 12:00:00 AM -> 00
1/1/1900 12:00:00 AM -> 00
6/15/2009 1:45:30 PM -> 09
"yyy"
 The year, with a minimum of three digits.
More information: The "yyy" Custom Format Specifier.
 1/1/0001 12:00:00 AM -> 001
1/1/0900 12:00:00 AM -> 900
1/1/1900 12:00:00 AM -> 1900
6/15/2009 1:45:30 PM -> 2009
"yyyy"
 The year as a four-digit number.
More information: The "yyyy" Custom Format Specifier.
 1/1/0001 12:00:00 AM -> 0001
1/1/0900 12:00:00 AM -> 0900
1/1/1900 12:00:00 AM -> 1900
6/15/2009 1:45:30 PM -> 2009
"yyyyy"
 The year as a five-digit number.
More information: The "yyyyy" Custom Format Specifier.
 1/1/0001 12:00:00 AM -> 00001
6/15/2009 1:45:30 PM -> 02009
"z"
 Hours offset from UTC, with no leading zeros.
More information: The "z" Custom Format Specifier.
 6/15/2009 1:45:30 PM -07:00 -> -7
"zz"
 Hours offset from UTC, with a leading zero for a single-digit value.
More information: The "zz" Custom Format Specifier.
 6/15/2009 1:45:30 PM -07:00 -> -07
"zzz"
 Hours and minutes offset from UTC.
More information: The "zzz" Custom Format Specifier.
 6/15/2009 1:45:30 PM -07:00 -> -07:00
":"
 The time separator.
More information: The ":" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> : (en-US)
6/15/2009 1:45:30 PM -> . (it-IT)
6/15/2009 1:45:30 PM -> : (ja-JP)
"/"
 The date separator.
More Information: The "/" Custom Format Specifier.
 6/15/2009 1:45:30 PM -> / (en-US)
6/15/2009 1:45:30 PM -> - (ar-DZ)
6/15/2009 1:45:30 PM -> . (tr-TR)
"string"
'string'
 Literal string delimiter.
6/15/2009 1:45:30 PM ("arr:" h:m t) -> arr: 1:45 P
6/15/2009 1:45:30 PM ('arr:' h:m t) -> arr: 1:45 P
%
 Defines the following character as a custom format specifier.
More information: Using Single Custom Format Specifiers.
 6/15/2009 1:45:30 PM (%h) -> 1
\
 The escape character.
 6/15/2009 1:45:30 PM (h \h) -> 1 h
Any other character
 The character is copied to the result string unchanged.
More information: Using the Escape Character.
 6/15/2009 1:45:30 AM (arr hh:mm t) -> arr 01:45 A
 
 

Comments

Post a Comment

Popular posts from this blog

Scrollable GridView with Fixed Headers using jQuery Plugin

Using the same example I have created a jQuery Plugin for Scrollable GridView with Fixed header so that you can directly make a GridView scrollable.   HTML Markup < form   id ="form1"   runat ="server"> < asp : GridView   ID ="GridView1"   runat ="server"   AutoGenerateColumns   =   "false"> < Columns > < asp : BoundField   DataField   =   "ContactName"   HeaderText   =   "Contact Name"   /> < asp : BoundField   DataField   =   "City"   HeaderText   =   "City"   /> < asp : BoundField   DataField   =   "Country"   HeaderText   =   "Country"   /> Columns > asp : GridView > form >   Applying the Scrollable Grid jQuery Plugin < script   src ="Scripts/jquery-1.4.1.min.js"   type ="text/javascript"> script > < script   src ="Scripts/Scro...
Post a Comment
Read more

GRIDVIEW GROUPING

When displaying data, we sometimes would like to group data for better user experience or when displaying long list of hierarchal data, we would want to display them in a tree view kind of structure. There is more than way of doing this, but I am going to explain achieving this functionality using  AJAX Collapsible Panel Extender Control . Overview: I am going to use  Adventure Works  as datasource. Every product in  Production.Product  table belongs to a product sub category. We fetch handful of products and the sub categories they belong to from the database. Our objective is to list all the available sub categories and allow user to  expand/collapse  to look/hide the list of products belonging to each subcategory. Database Connection Added following entry under  connectionStrings  element in  web.config . < add   name = "Sql"   connectionString="Data Source=(local); Initial  Catalog = AdventureWorks ...
Post a Comment
Read more

ADO.NET Concepts With example

COMMAND OBJECT  Command object is the biggest object in ADO.NET  It is the only object which can perform actions with database  It  can be created directly using Command class or can be created using Connection.Create command (factory classes also contain creation of Command). Ex:  SqlConnection sqlCon = new SqlConnection("......");    SqlCommand sqlCmd = sqlCon.CreateCommand();  Commands that we run depend upon the kind of query that we want to execute with database. All databases support two types of queries. i. Action Queries ii. Non-action Queries Action queries are those which change the state of database and which don‟t return any query results(though they return the number of records affected). Ex: Insert, Delete and Update statements Non-action queries are those which don‟t affect the database but return the results to the user. Ex: Select statement Method of execution of queries: Command object provides the following methods to execute queries: 1. Ex...
Post a Comment
Read more