Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
jge  
#1 Posted : Tuesday, August 26, 2014 9:08:14 PM(UTC)
jge

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):
datetime.jpg
datetime1.jpg
bbv  
#2 Posted : Tuesday, August 26, 2014 10:43:31 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 480

Was thanked: 81 time(s) in 81 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?
jge  
#3 Posted : Wednesday, August 27, 2014 2:16:42 PM(UTC)
jge

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):
start_time.jpg
bbv  
#4 Posted : Wednesday, August 27, 2014 3:57:17 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 480

Was thanked: 81 time(s) in 81 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):
Sample.png
jge  
#5 Posted : Thursday, August 28, 2014 3:22:52 PM(UTC)
jge

Rank: Advanced Member

Groups: Registered
Joined: 7/31/2014(UTC)
Posts: 40
Location: sterling, VA

see attached.
jge attached the following image(s):
time.jpg
jge  
#6 Posted : Thursday, August 28, 2014 3:23:26 PM(UTC)
jge

Rank: Advanced Member

Groups: Registered
Joined: 7/31/2014(UTC)
Posts: 40
Location: sterling, VA

see attached setup
jge attached the following image(s):
time2.jpg
bbv  
#7 Posted : Thursday, August 28, 2014 9:13:18 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 480

Was thanked: 81 time(s) in 81 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.
Users browsing this topic
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.