The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Incorrect time value in html report returned by web service
Contributor II
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
0
Answers
http://rapid-i.com/bugzilla/show_bug.cgi?id=1732