How to insert a reference to a blog in my entry?
SqlDateTime.Parse not culture sensitive?
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What is interesting here?
• Duels		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Register!
QAIX > .Net Development > SqlDateTime.Parse not culture sensitive? 18 June 2009 10:30:17
  Top users: 
1. Minako l Love friends l

"~Snowly the world ~"
Age: 14 years
2.Kipi Cosplay
"{•Sexy•}"

How to become a leader?
  Recent blog posts: 
How to rip DVD and convert…
Part 1 of ripping DVD and converting video and flash to iPod Video MP4 How to rip DVD to iPod…

How to play Video and DVD on…
Numerous friends play attention of phone may have noticed, in 2008 and 2009, the Android system has been…

Enjoy DVD and video on popular…
Android system has been taken into our memory early, many friends favor Smartphone input more energy to…

How to convert MKV to AVI, MP4…
MKV, also known as Matroska, is a multimedia container format. It is not a video or audio compression…

How to Play and Burn TS video…
Transport stream - TS (AVHD H.264, VC-1, MPEG-2 HD), is a communications protocol for audio, video, and…

Happy St. Patric`s day!
Happy St. Patric`s day!

MOD Converter- convert Mod to…
Many users had purchased HD digital cameras such as Panasonic SV AV100, Canon MOD Camcorders, JVC (MOD…

import/convert MOD files into…
According to my own experience importing JVC Everio camcorder .mod files into Windows Movie Maker, I…

how to import/convert/edit mod…
Adobe Premiere Pro is a professional, real-time, timeline based video editing software…

How to Transfer or Burn TiVo…
TiVo is a gorgeous digital video recorder with many features such as Season Pass recordings which ensure…

  They have birthday today: 
ayadav
giorgi
mohammed
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
System.ArgumentNullException…
hi ....remoting stuff: Server configuration: SoapServerFormatter­­SinkProvider provider = new…

Enterprise Library Exception…
I'm trying to use the Exception Block in Enterprise Library for Fx 2.0 for the first time. The project…

Checkbox value being lost on…
Hello all, I have been having a problem with a check box value not being restored after a postback…

ServiceController status…
This is a repost from CLR, doesn't seem like there is much activity over on that list. This isn't…
  Recent forum topics: 
ololol
ololol

Good afternoon.
Good afternoon.

olololllolololo who are you?I…
olololllolololo who are you? I am God! And I think that you asshole xD

Hey-hey!!
Hey-hey!!

blya a tut yesty hoty odin…
blya a tut yesty hoty odin 4elovek kotoriy realyno ne znaet russkogo?

aaa ya gost8-|
aaa ya gost8-|­
  Recent forum comments:
RE: Specified driver could not be…
When i run a program VOPT 9 to defragment my external hard drive because is much faster i get the error…

RE: PGSQL Database Recovery in…
nice tool. However, I have heard about another program for repair sql server suspect…

RE: MyISAM index file…
nice tool. However, I have heard about another program for microsoft sql server recovery…

RE: Another database recovery…
nice tool. However, I have heard about another mssql database restore tool…

RE: Full Recovery Model - log…
nice tool. However, I have heard about another program for sql recover ndf file…

RE: Recovery and Backup
nice tool. However, I have heard about another program for repair sql database 2005…

RE: RMAN block lever recovery…
nice tool. However, I have heard about another program for how to ensure queries executed in batch…

RE: pipes!!! 1 polzovatel na…
:-*­ :-*­ :-*­ :-*­ :-*­ :-*­ :-*­…

RE: neopets hacking
You people are stupid.

RE: neopets hacking
Wow, okayy. Anything, that's wanting you to give them your password, is A FUCKING SCAM! Neopets will…
  Модератор:
 Administrator

SqlDateTime.Parse not culture sensitive?

Mark Griffiths 19 April 2002 15:54:08
 The SqlDateTime.Parse()­ method does not seem to be honouring the current
culture. I am in the UK and have checked that
System.Globalizatio­n.CultureInfo.Curren­tCulture is set to "en-GB". I'm sure
everyone knows that in the UK we usually format our dates as dd/MM/yyyy.
From the immediate window:

?DateTime.Parse("1/­2/2002").ToString("d­d-MMM-yyyy")
"01-Feb-2002"

?SqlDateTime.Parse(­"1/2/2002").Value.To­String("dd-MMM-yyyy"­)
"02-Jan-2002"

DateTime.Parse works as expected, but SqlDateTime assumes a US format when
parsing the string.

Can anybody confirm this as a bug? or am I doing something wrong?

Mark

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.deve­lop.com.

Add comment
Guest 22 April 2008 13:22:21 [ permanent link ]
 I used the DateTime class first and then created the SqlDateTime correctly from it:

string s1 = "25/02/2008";

DateTime d = DateTime.Parse(s1.T­rim());
SqlDateTime d2 = new SqlDateTime(d.Year,­ d.Month, d.Day);


MessageBox.Show(d2.­ToString());
MessageBox.Show(d.T­oLongDateString());
Add comment
Guest 23 December 2008 23:34:52 [ permanent link ]
 
I used the DateTime class first and then created the SqlDateTime correctly from it:

string s1 = "25/02/2008";

DateTime d = DateTime.Parse(s1.T­rim());
SqlDateTime d2 = new SqlDateTime(d.Year,­ d.Month, d.Day);


MessageBox.Show(d­2.ToString());
MessageBox.Show(d­.ToLongDateString())­;

Thanks!!! :-)­
Add comment
Guest 18 June 2009 10:30:17 [ permanent link ]
 Thanks for idea. This could be the better approach:

lastUpdateTimeUtc = new SqlDateTime( ((FileInfo) fileInfo).LastWrite­TimeUtc );
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или законы РФ. Ваш ip-адрес записывается.

QAIX > .Net Development > SqlDateTime.Parse not culture sensitive? 18 June 2009 10:30:17
see also:
[Mail Services] - javamail Session…
[Clusters on JBoss (Clusters/JBoss)]…
[EJB on JBoss] - EJB3 meta model and…
pass tests:
see also:
  Copyright © 2001—2010 QAIX
Идея: Монашёв Михаил.
Авторами текстов, изображений и видео, размещённых на этой странице, являются пользователи сайта.
See Help and FAQ in the community support.qaix.com.
Write in the community about the bugs you have noticedbugs.qaix.com.
Write your offers and comments in the communities suggest.qaix.com.
Information for parents.
Пишите нам на .
If you would like to report an abuse of our service, such as a spam message, please .
Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .