Re: convert

It will recognize the T in the string. It is the number of digits that is
the problem. Either of these will work

select CONVERT(datetime, '2006-10-09T13:54:06.924')

select CONVERT(datetime, '2006-10-09 13:54:06.924')


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************************************************
Think outside of the box!
*************************************************
"Milosz Skalecki" <mily242@xxxxxxxxxxxxx> wrote in message
news:4AA25E9E-ADEF-4C4C-95A7-B14F88FC2B49@xxxxxxxxxxxxxxxx
Hello Oren,

SQL server doesn't recognize the string as a valid date string (T in the
string, number of digits, GMT bias), you must serialize it to proper
format
i.e:
select CONVERT(datetime, '2006-10-09 13:54:06.924')

hope this helps
--
Milosz Skalecki
MCP, MCAD


"Oren" wrote:

Hi,
I use DateTime.Now and Serialize an object into XML field (Sql 2005).
the problem is that:
select CONVERT(datetime, '2006-10-09T13:54:06.9248089+02:00')

ERROR: Conversion failed when converting datetime from character string.

Any idea ?


.

Relevant Pages

  • Re: How to convert extra long strings into their equivalent Hex Strings in VBA (Word 2K)
    ... numbers (upto 18 digits max) into its equivalent Hex String ... Public Function ExpressServiceCode(ByVal ServiceTag As String) As String ... 'the number dblTemp in the specified base, ... Dim lngTemp As Long ...
    (microsoft.public.vb.general.discussion)
  • Re: BigNum -- Floating Point
    ... The 'N' is the number of decimal digits. ... The internal representation is really just a string of bits. ... the number of shifts for various multiples of ten: ... The 'exponent' is very closely related to ...
    (comp.programming)
  • Patterns in pi, copyright law, and philosophy
    ... Whether the offset of a string found in pi can be used as a form on ... then calculate how many digits of pi one would need to raise the ... "An infinite series of numbers is not an exhaustive set of numbers. ... finite string of digits occurs within the decimal expansion of pi, ...
    (sci.math)
  • Re: Patterns in pi, copyright law, and philosophy
    ... The digits of pi are widely believed to be "normal", in the sense that every n digit combination of digits is equally likely, and pass all reasonable tests of randomness. ... The mean length of the offset must at least be equal or greater than the length of the string you are looking for. ... Pi has an infinite representation as a decimal. ... finite string of digits occurs within the decimal expansion of pi, ...
    (sci.math)
  • Re: Required Field for 7 Numeric digits only
    ... Function IsNumber(ByVal Value As String) As Boolean ... > works with verifying that it has 7 digits and is a numeric filled> textbox ... > Private Sub TextBox1_KeyPress ... > Dim IsValid As Boolean ...
    (microsoft.public.excel.programming)