DATETIMEPATTERN

K

Karunakararao

Hi all
How can i get the "Short Date Format" from regional and language
options
Like "MM/dd/yyyy"
how can get this type of format based regional settings;
I wnat to show this format in web application.

Iam using this code
Label1.Text = CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern;
Iam getting this output ="M/d/yyyy";

When ever chage the regional optional settings It's not changing when i was
used this code.


Regards
Venu
 
K

Karunakararao

Here Iam using in ASP.NET Web application
Here it is not taking the these settings
I want Format of like "MM/dd/yyyy"
Regards
Venu
 
V

Vaibhav

Hi,

You can try this one...
it worked for me

CONVERT(nvarchar(20), EnteredDate, 105)

Vaibhav
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DATEFORMAT based on reginoal settings 5
Regional settings made at the operating system level 1
Regional settings made at the operating system level 2
WebApplication - CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern--Not Working!! 0
DateTime.ToString 6
Forcing a date entry format of dd/mm/yyyy 1
How can i get the date formatted according to the regional settings made at the operating system le 3
Excel is changing date format incorrectly 7

Top