We had this problem when we upgraded. As I recall, we had to change our
taf files to use the date format that sql was expecting. (Scott, was
that what happened?)
Regards,
Len Wright
Plus International Corp
www.plusinternational.com
Direct: 604-415-2384
Fax:604-415-0830
>>> [EMAIL PROTECTED] 05/22/02 08:06AM >>>
Trying to migrate my DB from MS SQL 6.5 to 2000 and have a problem
with
dates.
In my taf I define local var where I store <@CURRENTTIMESTAMP>
I use this variable to insert value into a smalltimestamp type column
(let's
call that column STAMP)
Immediately after that I am searching for that record WHERE STAMP is
the
value of variable defined in the beginning.
However, the search fails and I noticed that:
1)the format of the variable value is 05/22/2002 10:48:16
2) Tango changes this format to {ts '2002-05-22 10:48:16'}, but it
changes
it for both - the insert, as well as the search actions.
Anybody has any ideas how to deal with this?
Thanks
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to
[EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
