How can we help you today? How can we help you today?

DateTime fields Error

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
>
>
Brian Donahue
0

Comments

1 comment

Sort by
  • Brian Donahue
    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
    >
    >
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.