please help me (DATABASE)-- sunil.android

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

please help me (DATABASE)-- sunil.android

Postby sunil.android » Wed Aug 05, 2009 5:40 pm

how to store the Date in database SQLite
Last edited by sunil.android on Thu Aug 06, 2009 2:24 pm, edited 1 time in total.
Thanks & Regards

Sun
sunil.android
Freshman
Freshman
 
Posts: 6
Joined: Mon Aug 03, 2009 6:17 pm

Top

Postby nmc » Wed Aug 05, 2009 7:10 pm

I use UNIX format (secs since jan 1970) as this is usable with java objects as well as c++ on pc (my data gets two-way-synced between pc and android, so i need a format that is handy for both platforms)
nmc
Senior Developer
Senior Developer
 
Posts: 154
Joined: Thu Nov 27, 2008 8:30 pm
Location: Germany

Postby sunil.android » Thu Aug 06, 2009 2:23 pm

I am working on WindowsXp..... I want to store the birth date into database ... how can i..????
plz help me...
Thanks & Regards

Sun
sunil.android
Freshman
Freshman
 
Posts: 6
Joined: Mon Aug 03, 2009 6:17 pm

Postby nmc » Thu Aug 06, 2009 6:33 pm

Since a birthday is likely to be before 1970, you shouldnt use the secs approach.
Use a string field instead; if you have to do calculations with that date, parse the data into your calendar/date whatever object while fetching rows.
nmc
Senior Developer
Senior Developer
 
Posts: 154
Joined: Thu Nov 27, 2008 8:30 pm
Location: Germany

Postby sunil.android » Fri Aug 07, 2009 5:19 pm

Thank you nmc.....
Thanks & Regards

Sun
sunil.android
Freshman
Freshman
 
Posts: 6
Joined: Mon Aug 03, 2009 6:17 pm

Top

Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 5 guests