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
