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/