[Shotwell] Ancient question

[Marcel Stimberg]

Hi Adam,

just out of curiosity:

> currently Shotwell correctly handles dates after January 1, 1970.  This is the start of Unix/POSIX time:
normally, a signed integer is used for this -- therefore this should
already allow dates back to 1902 even on 32Bit systems, shouldn't it?
And as you seem to use time_t as the datatype within shotwell, this
should even be a 64Bit integer on 64Bit systems and therefore be
enough for all dates and times...?

>>It would be cool to move everything to GDateTime and serialize that format as a 64-bit number of microseconds since the year 1 ...
This would have the slight disadvantage that you can't use sqlite date
and time functions (though you do not seem to use them, anyway).
sqlite does support the 64Bit integer UNIX time format, however. The
only disadvantage of that format is that it would not give you
microsecond precision which might indeed be useful for photos taken in
rapid succession (though I do not think any standard camera saves
sub-second timestamps...)

Cheers
  Marcel