datetime format error

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by chinawsb Fri, 04 Jan 2002 00:47

#313

Author: chinawsb
Date: Fri, 04 Jan 2002 00:47

8 lines
1273 bytes

Hi,everyone:
   I create a table with datetime format in SQL Server 2000,and in a
multi-tier client,I wan't update it some field values, I find the MIDAS
generate the SQL Command like this:
   sp_executesql 'Update XXX Set Value=@P0 where
AField=@P1',N'@P0=102,@P='2001-12-30 9:00 PM'
   But in table XXX,AField value like '2001-12-30 9:00:34.230',so the
command update nothing.Can you tell me what can I to do?

Re: datetime format error

#319

Author: John Graham
Date: Sun, 13 Jan 2002 15:55

14 lines
1520 bytes

The MS SQL Server DateTime data type contains seconds and milliseconds
components.  Send it fake seconds and millisecond values.
John

chinawsb wrote:

> Hi,everyone:
>    I create a table with datetime format in SQL Server 2000,and in a
> multi-tier client,I wan't update it some field values, I find the MIDAS
> generate the SQL Command like this:
>    sp_executesql 'Update XXX Set Value=@P0 where
> AField=@P1',N'@P0=102,@P='2001-12-30 9:00 PM'
>    But in table XXX,AField value like '2001-12-30 9:00:34.230',so the
> command update nothing.Can you tell me what can I to do?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads