VB.NET - To convert date time.now() to european date format
Asked By abinav shankar on 22-Sep-11 01:27 AM
hi
i want to convert to date time format to European format how to do it
Devil Scorpio replied to abinav shankar on 22-Sep-11 01:42 AM
Hi Abhinav,
Use this code
DateTime dt=DateTime.Now
dt.ToString("dd-MMM-yyyy")
aneesa replied to abinav shankar on 22-Sep-11 01:42 AM
System.Globalization.CultureInfo europian= new System.Globalization.CultureInfo("en-GB");
string europianOutput = DateTime.Now.ToString(europian);
DateTime europianDate = DateTime.Parse(europianOutput , europian);
aneesa replied to abinav shankar on 22-Sep-11 01:46 AM
1.System.Globalization.CultureInfo europian= new System.Globalization.CultureInfo("en-GB");
2.string europianOutput = DateTime.Now.ToString(europian);
3.
4. System.Globalization.CultureInfo american = new system.Globalization.CultureInfo("en-US");
5. string americanOutput = DateTime.Now.ToString(american);
aneesa replied to abinav shankar on 22-Sep-11 01:47 AM
1.System.Globalization.CultureInfo europian= new System.Globalization.CultureInfo("en-GB");
2.string europianOutput = DateTime.Now.ToString(europian);
3.
4. System.Globalization.CultureInfo american = new system.Globalization.CultureInfo("en-US");
5. string americanOutput = DateTime.Now.ToString(american);
Suchit shah replied to abinav shankar on 22-Sep-11 01:54 AM
In SQL Server used Cast or Convert function to Format DateTime value or column into a specific date format.Both function are used to convert datetime to varchar or string.
CAST function Syntax: CAST(expression as data_type)
Let's convert current date time to varchar
select cast(getdate() as varchar)
CONVERT function is used to change or convert the DateTime formats.By using convert function you can get only Date part or only Time part from the datetime.
CONVERT Function Syntax: CONVERT(data_type,expression,date Format style)
Let's take Sql Server DateTtime styles example:
|
Format
|
Query
|
|
USA mm/dd/yy
|
select convert(varchar, getdate(), 1)
|
|
ANSI yy.mm.dd
|
select convert(varchar, getdate(), 2)
|
|
British/French dd/mm/yy
|
select convert(varchar, getdate(), 3)
|
|
German dd.mm.yy
|
select convert(varchar, getdate(), 4)
|
|
Italian dd-mm-yy
|
select convert(varchar, getdate(), 5)
|
|
dd mon yy
|
select convert(varchar, getdate(), 6)
|
|
Mon dd, yy
|
select convert(varchar, getdate(), 7)
|
|
USA mm-dd-yy
|
select convert(varchar, getdate(), 10)
|
|
JAPAN yy/mm/dd
|
select convert(varchar, getdate(), 11)
|
|
ISO yymmdd
|
select convert(varchar, getdate(), 12)
|
|
mon dd yyyy hh:miAM (or PM)
|
select convert(varchar, getdate(), 100)
|
|
mm/dd/yyyy
|
select convert(varchar, getdate(), 101)
|
|
yyyy.mm.dd
|
select convert(varchar, getdate(), 102)
|
|
dd/mm/yyyy
|
select convert(varchar, getdate(), 103)
|
|
dd.mm.yyyy
|
select convert(varchar, getdate(), 104)
|
|
dd-mm-yyyy
|
select convert(varchar, getdate(), 105)
|
|
dd mon yyyy
|
select convert(varchar, getdate(), 106)
|
|
Mon dd, yyyy
|
select convert(varchar, getdate(), 107)
|
|
hh:mm:ss
|
select convert(varchar, getdate(), 108)
|
|
Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM)
|
select convert(varchar, getdate(), 109)
|
|
mm-dd-yyyy
|
select convert(varchar, getdate(), 110)
|
|
yyyy/mm/dd
|
select convert(varchar, getdate(), 111)
|
|
yyyymmdd
|
select convert(varchar, getdate(), 112)
|
|
Europe default + milliseconds dd mon yyyy hh:mm:ss:mmm(24h)
|
select convert(varchar, getdate(), 113) or select convert(varchar, getdate(), 13)
|
|
hh:mi:ss:mmm(24h)
|
select convert(varchar, getdate(), 114)
|
TO_DATE('1998-DEC-25 17:30','YYYY-MON-DD HH24:MI','NLS_DATE_LANGUAGE=AMERICAN')
check below link also
http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx
http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/
AM Dim tsTimeSpan As TimeSpan Dim iNumberOfDays As Integer Dim dtDate, dtDate2 As Date dtDate = DateTime.Parse(TextBox1.Text, Globalization.CultureInfo.CreateSpecificCulture("en-CA")) dtDate2 = DateTime.Parse(TextBox2.Text, Globalization.CultureInfo.CreateSpecificCulture("en-CA")) tsTimeSpan = dtDate2.Subtract(dtDate) iNumberOfDays = tsTimeSpan.Days when i using this code ParseExact ( "24 / 5 / 2009 3:40:00 AM" , "d / M / yyyy h:mm:ss tt" , CultureInfo . InvariantCulture ) . ToString ( "M / d / yyyy h:mm:ss tt" ) See also: • http: / / msdn.microsoft.com days = ts.Days; int hrs = ts.Hours; int min = ts.Minutes void countDays() { DateTime d1 = DateTime .Parse(txtFrom.Text); DateTime d2 = DateTime .Parse(txtTo.Text); TimeSpan span = d2 - d1; Console .WriteLine
Dim numberofdays As Double Dim tsTimeSpan As TimeSpan Dim provider As IFormatProvider = New System.Globalization.CultureInfo("en-CA", True) Dim dt1Date1, dtDate2 As Date dt1Date1 = DateTime.Parse(txtFromDate.Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault) dtDate2 = DateTime.Parse(txtToDate.Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault) tsTimeSpan = dtDate2.Subtract(dt1Date1) numberofdays = tsTimeSpan.Days when 9 days . . . . . . so give me the solution plz Private Sub countDays() Dim d1 As DateTime = DateTime.Parse(txtFrom.Text) Dim d2 As DateTime = DateTime.Parse(txtTo.Text) Dim span As TimeSpan = d2 - d1 Console.WriteLine("There're {0} days
Use IFormatProvider to do DateTime.Parse for different cultures. IFormatProvider can be used to do DateTime Conversions to various other cultures following sample shows conversion of a datetime variable value to French culture. IFormatProvider myCulture = new CultureInfo("fr-Fr", true); DateTime dt = DateTime.Parse(myDateTimeString, myCulture, DateTimeStyles.NoCurrentDateDefault); Parsing Datetime to a different format ( 575 Views ) keywords: IFormatProviderDateTime, Conversions, CultureInfo, Parse, DateTimeStyles.NoCurrentDateDefault description: Use IFormatProvider to do DateTime.Parse for different cultures.
Dim numberofdays As Double Dim tsTimeSpan As TimeSpan Dim provider As IFormatProvider = New System.Globalization.CultureInfo("en-CA", True) Dim dt1Date1, dtDate2 As Date dt1Date1.ToString("MM / dd / yyyy HH:mm:ss") dtDate2.ToString("MM / dd / yyyy HH:mm:ss") dt1Date1 = DateTime.Parse(txtFromDate.Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault) dtDate2 DateTime.Parse(txtToDate.Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault) tsTimeSpan = dtDate2.Subtract(dt1Date1) numberofdays = tsTimeSpan.Days when Dim numberofdays As Double Dim tsTimeSpan As TimeSpan Dim provider As IFormatProvider = New System.Globalization.CultureInfo("en-CA", True) Dim dt1Date1, dtDate2 As Date dt1Date1.ToString("MM / dd / yyyy HH:mm:ss") dtDate2.ToString("MM / dd / yyyy HH:mm:ss") dt1Date1 = DateTime.Parse(txtFromDate.Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault) dtDate2 = DateTime.Parse(txtToDate.Text, provider, System.Globalization
Dim numberofdays As Double Dim tsTimeSpan As TimeSpan Dim provider As IFormatProvider = New System.Globalization.CultureInfo("en-CA", True) Dim dt1Date1, dtDate2 As Date dt1Date1 = DateTime.Parse(txtFromDate.Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault) dtDate2 = DateTime.Parse(txtToDate.Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault) tsTimeSpan = dtDate2.Subtract(dt1Date1) numberofdays = tsTimeSpan.Days when Dim numberofdays As Double Dim tsTimeSpan As TimeSpan Dim provider As IFormatProvider = New System.Globalization.CultureInfo(en
getting error as input stiring was not in correct fromat. . please help me. . DateTime fromdate = DateTime.Parse(calendar1_container.Text).Date; DateTime todate = DateTime.Parse(calendar2_container.Text).Date; if (todate.CompareTo(fromdate) < 0) { messagebox("expiry date shouldbe greater than registration you to specify the format etc eg dateString = "03 / 01 / 2009 10:00 AM" ; culture = CultureInfo.CreateSpecificCulture( "en-US" ); styles = DateTimeStyles.None; if (DateTime.TryParse(dateString, culture, styles, out dateResult)) Console microsoft.com / en-us / library / 9h21f14e.aspx Whatever this is calendar1_container.Text - - You are doing DateTime.Parse on this and then asking for its .Date property, but calendar1_container.Text is not a is checking for dd / mm / yyyy format. . check the above two mentioned criterias DateTime fromdate = DateTime.Parse(calendar1_container.Text).Date; DateTime todate = DateTime.Parse(calendar2_container.Text).Date; keywords: DateTimeStylesCreateSpecificCulture, DateTime, date
datetime parse work exactly when date format is like mm / dd / yyyy but when dateformat is like datetime. so what should i do. . . i use code like IFormatProvider culture = new System . Globalization . CultureInfo ( "en-US" , true ); string xxx = DateTime . ParseExact ( "15 / 12 / 2012" , "yyyyMMdd" , culture ). ToString (); it does dt6.ToString( "dd:MM:yyyy" ); keywords: IFormatProvider, DateTime, date, ParseExact, date format, parse, dd description: datetime parse issue c# datetime parse work exactly when date format is like mm / dd / yyyy but when dateformat is
depDt = new DateTime (); DateTime ariDt = new DateTime (); string depDt1 = "" , ariDt1 = "" ; IFormatProvider mFomatter = new System.Globalization. CultureInfo ( "en-US" ); depDt = DateTime .Parse(txtDepDate.Text.Trim(), System.Globalization. CultureInfo .CreateSpecificCulture( "en-CA" )); if (txtAriDate.Text ! = "" ) { ariDt = DateTime .Parse(txtAriDate.Text.Trim(), System.Globalization. CultureInfo .CreateSpecificCulture( "en-CA" )); } The CultureInfo class renders culture-specific information, such as the associated language, sublanguage, country / region, calendar, and
hai guys , DateTime date1 = DateTime .Parse(TextBox1 .Text ); Label1 .Text = date1.Date.ToString( "dd" ); this my code . i enter a value dt.ToLongDateString(); / / Get short date string string shortDate = dt.ToShortDateString(); Whenever we didn't pass CultureInfo at the time of Parsing string to DateTime, it will consider the date in MM format. So you can do something like below to get the day only. . DateTime date1 = DateTime .Parse(TextBox1 .Text ); int iDay = date1.Day.ToString(); int iDay = date1.Day.ToString(); Whenever we didn't pass CultureInfo at the time of Parsing string to DateTime, it will consider the date in MM format. So you can do something like below to get the day only. . DateTime date1 = DateTime .Parse(TextBox1 .Text ); int iDay = date1.Day; int iDay = date1.Day; keywords: ToShortDateStringToLongDateString, ToDateTime, DateTime, ASP