John Decowski Member Licensed User Longtime User Dec 29, 2019 #1 I have a mySql datebase with a date/time field. When i view it in mysql it views as a date fine. I can even add to the date fine with JRDC. But the problem happens when I query the results from JRDC to my android app I get some weird long integer that doesn't resemble a date at all. for instance my sql says field value is: 2012-12-19 00:00:00 comes back as : 1355875200000 Every other field returns fine. Just issue with the date/ time field. sorry if this issue has been already address elsewhere but I did try and find in the search. Thanks alot
I have a mySql datebase with a date/time field. When i view it in mysql it views as a date fine. I can even add to the date fine with JRDC. But the problem happens when I query the results from JRDC to my android app I get some weird long integer that doesn't resemble a date at all. for instance my sql says field value is: 2012-12-19 00:00:00 comes back as : 1355875200000 Every other field returns fine. Just issue with the date/ time field. sorry if this issue has been already address elsewhere but I did try and find in the search. Thanks alot
Alexander Stolte Expert Licensed User Longtime User Dec 29, 2019 #2 it is not an Integer, it is a long. And the result are "Ticks", you can easy convert this ticks to string with the DateUtils-Class: DateUtils.TicksToString(978.....) Upvote 0
it is not an Integer, it is a long. And the result are "Ticks", you can easy convert this ticks to string with the DateUtils-Class: DateUtils.TicksToString(978.....)
John Decowski Member Licensed User Longtime User Dec 29, 2019 #3 Alexander Stolte said: it is not an Integer, it is a long. And the result are "Ticks", you can easy convert this ticks to string with the DateUtils-Class: DateUtils.TicksToString(978.....) Click to expand... thank you didn't understand the reason of it being an long value. I see now. Upvote 0
Alexander Stolte said: it is not an Integer, it is a long. And the result are "Ticks", you can easy convert this ticks to string with the DateUtils-Class: DateUtils.TicksToString(978.....) Click to expand... thank you didn't understand the reason of it being an long value. I see now.
Alexander Stolte Expert Licensed User Longtime User Dec 29, 2019 #4 John Decowski said: thank you didn't understand the reason of it being an long value. I see now. Click to expand... huh? ? Edit: ahhhh, you forgot the "," this confused me ? Upvote 0
John Decowski said: thank you didn't understand the reason of it being an long value. I see now. Click to expand... huh? ? Edit: ahhhh, you forgot the "," this confused me ?
