DateTime fields Error

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited April 19, 2004 7:24AM in SQL Data Compare Previous Versions
Hi Giuliano,

Thanks for writing us about this. We are going to see if we can get this
fixed.

Regards,

Brian Donahue
Red Gate Technical Support


"Giuliano Cornacchiola" <gcornacchiola@libero.it> wrote in message
news:g3c8A8ODEHA.3488@server53...
> Hi!
> I'm trying your very powerfull software, but I found an error when I tried
> to synchronize table with datetime fields...
> The problems seems the implicit convert from char to datetime in the
script.
> Ex:
> INSERT INTO [dbo].[tblLogConnessioniUtenti] ([nIDLogConnessioneUtente],
> [nIDConnessioneUtente], [nIDEvento], [dtData], [nIDTabella], [nIDRecord],
> [nIDSysObject], [sNote]) VALUES (23, 1468, 12, '20040301 13.50.55.807',
55,
> 1, 946818435, NULL)
>
> You use the '.' char to separate the hour, minutes, seconds, millseconds
> elements...
> But the SQL 2K in Italian language use the ':' separator...
>
> In fact the follow script in Query Analyzer run fine:
> INSERT INTO [dbo].[tblLogConnessioniUtenti] ([nIDLogConnessioneUtente],
> [nIDConnessioneUtente], [nIDEvento], [dtData], [nIDTabella], [nIDRecord],
> [nIDSysObject], [sNote]) VALUES (23, 1468, 12, '20040301 13:50:55:807',
55,
> 1, 946818435, NULL)
>
> Thanks
> Best regards
>
> Giuliano Cornacchiola
> EuroService Srl
>
>
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    The fix for this will appear in the next release of Data Compare.

    Thanks again for pointing it out to us!

    Regards,

    Brian Donahue
    Red Gate Technical Support

    "Giuliano Cornacchiola" <gcornacchiola@libero.it> wrote in message
    news:g3c8A8ODEHA.3488@server53...
    > Hi!
    > I'm trying your very powerfull software, but I found an error when I tried
    > to synchronize table with datetime fields...
    > The problems seems the implicit convert from char to datetime in the
    script.
    > Ex:
    > INSERT INTO [dbo].[tblLogConnessioniUtenti] ([nIDLogConnessioneUtente],
    > [nIDConnessioneUtente], [nIDEvento], [dtData], [nIDTabella], [nIDRecord],
    > [nIDSysObject], [sNote]) VALUES (23, 1468, 12, '20040301 13.50.55.807',
    55,
    > 1, 946818435, NULL)
    >
    > You use the '.' char to separate the hour, minutes, seconds, millseconds
    > elements...
    > But the SQL 2K in Italian language use the ':' separator...
    >
    > In fact the follow script in Query Analyzer run fine:
    > INSERT INTO [dbo].[tblLogConnessioniUtenti] ([nIDLogConnessioneUtente],
    > [nIDConnessioneUtente], [nIDEvento], [dtData], [nIDTabella], [nIDRecord],
    > [nIDSysObject], [sNote]) VALUES (23, 1468, 12, '20040301 13:50:55:807',
    55,
    > 1, 946818435, NULL)
    >
    > Thanks
    > Best regards
    >
    > Giuliano Cornacchiola
    > EuroService Srl
    >
    >
    · Share on Twitter
This discussion has been closed.