To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=75699
Issue #|75699
Summary|Query design converts timestamp of midnight to date on
|ly
Component|Database access
Version|OOo 2.1
Platform|All
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|dlairmarc
------- Additional comments from [EMAIL PROTECTED] Sat Mar 24 06:53:46 +0000
2007 -------
OOo 2.1
MS XPsp2
When trying to construct a timestamp (datetime) value in the query design grid
to select a date with 00:00:00, the resulting SQL is converted to a date only
field.
#2007-03-01 00:00:00# becomes {D '2007-03-01'} instead of {TS '2007-03-01
00:00:00'}
#2007-03-01 00:00:01# becomes {TS '2007-03-01 00:00:01'}
Informix IN9 complains when an SQL query is formated as date only when the field
in question is defined as a timestamp or datetime field.
In my case, I need to query on sales records where the date field is defined as
'YYYY-MM-01 00:00:00' for each sales month. The Informix ODBC driver complains
when presented with a date only format for this field.
Native mode can be used as a workaround, but any changes made to the query using
the query design grid translates the datetime value back to a date only format.
This forces a re-edit in native mode to correct.
On a side note: if the criteria of the timestamp field is paramaterized (ie.
=[mydatetime]), entering a midnight time passes properly.
In working with a MySQL database, this conversion doesn't seem to be an issue,
as the MySQL driver allows the date only format against a datetime field and as
long as the time portion of the field data is midnight, then the query succeeds.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
