Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC)
Posts: 40
Location: sterling, VA
|
I setup the datetime field as [M01]/[D01] at [H01]:[m01] however, the screen show 08/25 at 22:-118 Any clue? jge attached the following image(s):
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
I assume that the values which you are trying to display are not properly formatted dateTime values, because you also have a problem with negative hours in some lines.
Can you show us your actual @START_TIME values which result in this wrong formatting.
Also, what column type is it in your Oracle database?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC)
Posts: 40
Location: sterling, VA
|
the field start_time in oracle table is Date Type. The actual value for first record shipmentId = 1235102 is: 8/25/2014 1:21:53 PM by following statement: select shipment_xid,start_time from shipment where shipment_xid = '1235102' jge attached the following image(s):
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
What I need from you how your @START_TIME looks when retrieved in MobileTogether. Can you attach a screenshot from Simulator when running your app. Something like this: bbv attached the following image(s):
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC)
Posts: 40
Location: sterling, VA
|
see attached. jge attached the following image(s):
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC)
Posts: 40
Location: sterling, VA
|
see attached setup jge attached the following image(s):
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
Thanks for the screenshot - you have actually confirmed what we have assumed - all you get is the Date part, though an Oracle DATE columns can also have time within them. We have made a fix internally to also retrieve time from Oracle DATE columns, but for you in order not to wait for our next release I would suggest to do the following:
Instead of retrieving START_TIME field in your SELECT statement directly, you can convert it to a string in XML dateTime format, by copying this into your SELECT statement
TO_CHAR ("START_TIME", 'YYYY-MM-DD"T"HH24:MI:SS') "START_TIME"
As I said - this is a temporary workaround which will become obsolete with the next release. But wanted to help you already now.
By the way, you also need to directly show @START_TIME attribute in your label, instead of using last-chars( @START_TIME, 11 ) - you must supply the whole dateTime so that formatting functionality can properly render your date and time components.
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
