Hi Dan
I have only had experience with Tango and MS SQL and so can only comment
on this combination.
I have had this error before and as far as I can tell the problem comes
from the Tango side when you do not specify the full year. You can
easily check this by creating a direct DBMS with sql such as
set dateformat dmy insert table values ('01/04/02')
MS SQL seems to default with the current year and will insert the record
as 2002-04-01. If you then do an insert with an insert statement in
Tango without specifying the full year then it will inset as 1902-04-01.
Also, Tango picks up the smalldate type as type timestamp and when it
inserts the data will want to create sql of the form
INSERT INTO dbo.table (thedate) VALUES ({ ts '2002-04-01 00:00:00' })
I had this error years ago and since then have always used the full year
and specified format=datetime:@@timestampformat since then. I do not
know if this will be the best solution but if you absolutely have to use
2 digit dates then I would suggest using something like
"format=datetime:20%y-%m-%d" on all your inserts (although be carefull
of doing this as your code will only work for the next 97 years ha
ha...).
Regards
Trevor
-----Original Message-----
From: Dan Stein [mailto:[EMAIL PROTECTED]]
Sent: 02 June 2002 03:23 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Dates Again Second Try
OK let me try asking it this way.
Under what circumstances would a insert or update of a records write out
as
1902 instead of 2002.
DB Windows SQL 2000 SP ( not know for sure)
WiTango App server SP1
Windows 2000 Server
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
________________________________________________________________________
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
