Incorrect time value in html report returned by web service
champion
New Altair Community Member
Hello guys. I published my process as service which returns html report and for this case RA returns incorrect time value for timestamp fields fetched from mysql (not datetime).
RA muddled minutes and month fields. When should be month it puts minutes.. see below
In this table you can see timestamp value (i don't know why it presented on this format.. LC_TIME not act on it..) and value casted to string by function CAST(date_reg as char) and query was
How can I fix it? It not depends of system time zone.. Is it a bug,,?
RA muddled minutes and month fields. When should be month it puts minutes.. see below
In this table you can see timestamp value (i don't know why it presented on this format.. LC_TIME not act on it..) and value casted to string by function CAST(date_reg as char) and query was
SELECT date_reg, CAST(date_reg as char) from clients
Tagged:
0
Answers
-
Cool! Thank's to Simon Fisher - will be fixed in the next release!
http://rapid-i.com/bugzilla/show_bug.cgi?id=17320