timestamp handling not consistent when same date and time data is supplyed
--------------------------------------------------------------------------
Key: DNET-99
URL: http://tracker.firebirdsql.org/browse/DNET-99
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.0.1
Environment: Windows XP Professional, Visual Basic Express 2005
Reporter: luigi
Assignee: Carlos Guzman Alvarez
Priority: Critical
Dear All, I will appreciate Your suggestions on how to come out from the
problem reported below.
Using the following method when filling fields and creating records across two
different tables, where each table has a TIMESTAMP (NOT NULL) field, the MONTH
is swapped with the DAY.
aString=New System.DateTime(CInt(sYEAR), CInt(sMONTH), CInt(sDAY), CInt(sHOUR),
CInt(sMINUTE), CInt(sSECOND)).ToString("yyyy-MMMM-dd hh:mm:ss")
So far, when creating a record for table 1 having the following date
"2004-marzo-12 08.48.39" set into aString and another record for table 2 with
the same date, then table 1 has the MONTH that's swapped with the DAY if
compared with the records in table2.When browsing through the records...table 1
shows its records with the timestamp field having a value of December the 3rd,
2004, while table 2 shows its records with a timestamp set (correctly) to March
the 12, 2004.
By the way, I've tryed with all of the possible timestamp formats, as for
MM-dd-yyyy, dd-MM-yyyy, ecc. (such formats have been applied across all the
table insert functions, but the problem it's still there).
Thanks
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
