culture and datetime format

[mpl]

Hi,
I am using culture for my asp.net appliacation .my grid is having a date field which displayes in the format 22/1/2008 00:00:00 after the below code

Thread.CurrentThread.CurrentCulture = New CultureInfo("en-GB")

how can i remove the hours,mintes,second in the format string ?

thanks
mp

[kenobewan]

Certainly, date.parse(thisDate,"dd/MM/yyyy") should work.

[mpl]

where do u expect me to put this code ?
mp

Certainly, date.parse(thisDate,"dd/MM/yyyy") should work.

[Plater]

The default .ToString() format for DateTime is to have the hours and minutes as you have seen.
You will need to override it to something like .ToString("mm/dd/yyyy") if you only want the date portion.
You can also remove the time portion from within your SQL querry if you want, but the column will come out as a string and not a date. (Although you could then do a DateTime.Parse() on the string to get a DateTime object)

[mpl]

hi,
but my culture may change .it will be in US format like this.its bascially comming from database

Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")

then how will deal this

mp

[Plater]

If the column is a date column in your database, then the culture will have no effect on it.
DateTimes are stored the same regardless of culture, culture only effects how it will be displayed.

[mpl]

ur right.culture is only for display.but my database field is datetime ,
but i need to display it based on the culture i set for each of my client in a table

regards
mp

If the column is a date column in your database, then the culture will have no effect on it.
DateTimes are stored the same regardless of culture, culture only effects how it will be displayed.

[Plater]

do you know what the string format should be for each culture? (like "mm/dd/yyyy" or whatever)

[mpl]

here u can see the list of cultures.

http://msdn2.microsoft.com/en-us/library/system.globalization.cultureinfo(VS.80).aspx

i know for US its mm/dd/yyyy and for UK its dd/mm/yyyy
and for German its dd.mm.yyyyy .this i could get from the regional setting of the machine . the rest will have again somthing different...


regards
melbin

do you know what the string format should be for each culture? (like "mm/dd/yyyy" or whatever)

[Plater]

Well if you knew what they were, you could use the .ToString() method to change based on the culture you set.
Actually you could probably just use .ToShortDate() and I *think* it will only show the date in the current culture format.

I don't do much with cultures though.

[mpl]

thanks for the reply .i am using a thirdparty webgrid(intersoft) to populate the data.let me check anything can be done

thanks
mp

Well if you knew what they were, you could use the .ToString() method to change based on the culture you set.
Actually you could probably just use .ToShortDate() and I *think* it will only show the date in the current culture format.

I don't do much with cultures though.