sqlite writing a date into an email

Question

Hi, I am exporting a date value from sqlite and placing it into an email. The date appears like this 279498721.322872

I am using Objective C in an Iphone App. Does anyone know how to make this export out as a regular date whether it is all number like 2009-02-10 or anything legible?

Answer 1

echo date("Y-m-d",time(279498721.322872));

Answer 2

Well, if you take the number 279498721.322872 and throw it into an NSDate object using +dateWithTimeIntervalSinceReferenceDate, you get (here in the MDT timezone): 2009-11-09 15:32:01 -0700, which was just under 4 hours ago. If that's the time you're expecting, then formatting it is as simple as using an NSDateFormatter.

However, the thing to notice is that sqlite (by default) stores dates as textual representations (unless you specify differently in the sql statement). So the real question here is "where are you getting that number from?"

Answer 3

Thanks for the responses. The answer came from my Guru Alex Cone. He told me to use the following:

NSTimeInterval tempInterval = (NSTimeInterval)sqlite3_column_double(statement, 4);

The tempInterval variable can then be loaded into the the NSDate method.