Re: Inserting regional settings specific data into sql server

Tech-Archive recommends: Fix windows errors by optimizing your registry

If somebody is using a format setting that is not equal to his own
computer, than you can use probably the best in advance the dateTime.parse
and/or dateTime.parseExact first in which you can tell what is the culture
of that datetime string.

This as well as the date and time comes in a textfile or html file as string
in a home made format as in past where made (this cannot in another way in
a file except an XML file)

ddMMyyyy or ddMMyy or ddMMy or whatever.

You can than use the DateTime.ParseExact with Iformatprovider and the right
paterns

ParseExact overloaded version (string, string etc)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimeclassparseexacttopic3.asp


DateTimeFormatInfo
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemglobalizationdatetimeformatinfoclasstopic.aspMaybe is that what you are looking for and are you receiving the date timesas documents.Cor

.

Relevant Pages

  • Re: Dates
    ... The conversion of a char data type to a datetime data type resulted in an ... out-of-range datetime value. ... System.Data.Common.DbDataAdapter.FillFromReader(Object data, String ... srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DateTime WebService Discrepancy.
    ... When the datetime is sent by the webservice, ... > Ofcourse I had not even though of just passing a string as a parameter ... > locally and cut out the call to the web service. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Axis <-> .Net xsd:date interoperability problem
    ... .NET can de-serialize from alternative string representations of the date, ... but you need to tell it the format to expect. ... DateTime to be set. ... serialization of all DateTime's. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: DateTIme help
    ... Formatting happens at the moment of generating a string from ... Importing a string into a DateTime object. ... I'm not going to use the built in parsing and culture functionality. ...
    (microsoft.public.dotnet.framework)
  • Re: Zeitzonen und Benutzerdefinierte Formate --- Problem
    ... "Die Zeichenfolge wurde nicht als gültiges DateTime erkannt." ... Public Function ConvertDateTimeToCulture(ByVal sDateTime As String, ... Dim InputCulture = New ... Thread.CurrentThread.CurrentCulture = InputCulture ...
    (microsoft.public.de.german.entwickler.dotnet.vb)