|
|
Posted by invy on 11/20/06 15:46
Hi,
I'm a newbie to SQL SERVER world. My program(writen in
Pro*C) uses both SQLAIW32.DLL and SQLAKW32.DLL libraries. We have two
versions. ie, V1 and V2 with 2 pairs of theses DLLs. My problem is when
i execute INSERT statment with Date functions (like SELECT getdate()),
from V1 it is INSERTING with time seconds-millisecs . But in V2 it is
not giving seconds, like "Nov 20 2006 5:55PM ". (I had observed that
Select getdate() function in both cases returning without seconds ie,
like "Nov 20 2006 5:55PM " , though the insertion is taken place in
first(V1) is with seconds). Both dlls used in both versions are same.
ie, same versions, same timestamp, same size etc. I have replaced the
the dlls of V2 with ones in V1. Then it is INSERTing with seconds.
Then I tried to alter the combination of the dlls (ie, SQLAIW32.DLL of
V1 with SQLAKW32.DLL of V2 and vice versa) for the Version V2. Then
also it is it is INSERTING time with seconds. Only the combination in
V2 makes the problem. Is it a build problem?? Can any one explain to
me??? Details are given below.
Version of Both DLLs in V1 and V2
File Version= 1998.11.13.0
Product Version=7.00.623
select statment:
EXEC SQL SELECT GETDATE() INTO :DATE
insert statment:
EXEC SQL INSERT INTO table( date ) VALUES ( :DATE );
Navigation:
[Reply to this message]
|