Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Native Development

Reply
Contributor
mponline
Posts: 29
Registered: ‎05-28-2013
My Device: z10
Accepted Solution

sqlite date format issues

 

I am trying to format a date that is stores ina local database. The step time function does seem to be returning anything as I get blank. Below is an example. 

 

Select strftime('%m/%d/%Y', 'mytime') from record_table

 

Developer
simon_hain
Posts: 16,282
Registered: ‎07-29-2008
My Device: Z10 LE, Z30, Passport

Re: sqlite date format issues

retrieve the value first, then modify/format it.
----------------------------------------------------------
feel free to press the like button on the right side to thank the user that helped you.
please mark posts as solved if you found a solution.
@SimonHain on twitter
Contributor
mponline
Posts: 29
Registered: ‎05-28-2013
My Device: z10

Re: sqlite date format issues

Yes. That's what I ended up doing. I suppose the sqlite date/time functions isn't supported in 10.1 yet.