After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 160845 - mysql timestamp type to_string makes a mess
mysql timestamp type to_string makes a mess
Status: RESOLVED OBSOLETE
Product: libgda
Classification: Other
Component: MySQL provider
unspecified
Other Linux
: Normal normal
: ---
Assigned To: Rodrigo Moya
gnome-db Maintainers
Depends on:
Blocks:
 
 
Reported: 2004-12-09 09:13 UTC by Alan Knowles
Modified: 2007-02-05 14:21 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Alan Knowles 2004-12-09 09:13:52 UTC
we define timestamp as this:
{ "timestamp", "", "Time stamp", GDA_VALUE_TYPE_TIMESTAMP },

unfortunatly, AFAIR gda value timestamps are pretty much expected to be iso
formated, or similar, a mysql timestamp uses the format yyyymmddhhiiss
hence using to_string on it produces strange results.
a few options exist to work around this:
a) use GDA_VALUE_TYPE_STRING
b) modify fill_gda_value to convert timestamps (that are not null) to iso
format.. (by adding a few - / :'s)
Comment 1 Murray Cumming 2007-01-30 08:42:26 UTC
Sorry, I don't understand what this bug report is requesting. What part of the code is this about? How would the problem be experienced?
Comment 2 Murray Cumming 2007-02-05 14:21:10 UTC
Please do reopen this bug if there still seems to be a problem. For now, I'm closing it as too old to be relevant.