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

Adobe AIR Development

Posts: 235
Registered: ‎12-13-2011
My Device: Curve 9380
My Carrier: Vodafone-IN

how to save date in sqlite database?


       I am trying to add date in database.I need to place only dd/mm/yy from device date.. also I need to check the date difference from sqlite.. Have any idea about this please help me




Posts: 1,280
Registered: ‎03-03-2011
My Device: Playbook, Z10, Q10, Z30 with Files & Folders and Orbit of course
My Carrier: Vodafone

Re: how to save date in sqlite database?

Try this: http://lmgtfy.com/?q=date+sqlite+air

Files & Folders, the unified file & cloud manager for PlayBook and BB10 with SkyDrive, SugarSync, Box, Dropbox, Google Drive, Google Docs. Free 3-day trial! - Jon Webb - Innovatology - Utrecht, Netherlands
Posts: 6,541
Registered: ‎10-27-2010
My Device: HTC One, PlayBook, LE Z10, DE Q10
My Carrier: Verizon

Re: how to save date in sqlite database?

You can save as string, but in a YYYY/MM/DD format so comparisons can be made. You can save it as an integer (Unix time) for faster comparisons. You will need to truncate the time if that is not important.
Posts: 614
Registered: ‎10-17-2010
My Device: (BlackBerry Z10)-> Q10/Passport Dual Use

Re: how to save date in sqlite database?

Innovatology wrote:

Try this: http://lmgtfy.com/?q=date+sqlite+air

Bump. I would like a helpful resource.