Strange Behavour in OLEDB and MS-SQL Server 2005

[panagiotismamatsis]

Good evening to all,
i am using powerbuilder ver. 10.2.1.9004 to connect to an
MS-SQL Server 2005 database using the OLEDB drivers.
The situation is that even though i have specified into
the
DBParm the "DateTimeFormat" and "TimeFormat" when i am
using
the "Today()" powerscript function as initial value into
the
datawindow object then the PB runtime is assigning to the
column also milliseconds.
In the "DateTimeFormat" i have put ''dd/mm/yyyy
hh:mm:ss'' and
in the "TimeFormat" i have put ''hh:mm:ss''. Now,
according to
the sybase books online those two DBParm parameters are
responsible for the "build" of the sql that the runtime
is
sending to the database. Since i have not specified
anywhere
the milliseconds into the format isn't it logical for the
runtime to truncate them prior to send the data to the
database ? Did anyone else had a similar problem ?

Thank you all in advance,
Panagiotis Mamatsis.

[Paul Vero [Sybase]]

You should post this to the powerbuilder newsgroup as this one is used for
ASE
OLE DB

Thank you,

-Paul

<Panagiotis Mamatsis> wrote in message
news:4b1ff2c3.253...@sybase.com...