On 30 Jun 08, at 08:14, Jens Alfke wrote:
On 30 Jun '08, at 12:29 AM, David Arve wrote:

sqlite3_bind_int(sql_statement, 1, one_week);

Shouldn't that be sqlite3_bind_double? The variable one_week is declared as double, and I'm pretty sure that seconds-since-1970 intervals are soon going to overflow a (signed) 32-bit int, if they haven't already.

time_t (seconds since 1970, signed 32-bit integer) doesn't overflow until early 2038 - at which point there is mass panic, riots in the streets, and blood raining from the skies, because a ton of protocols have the 32-bit width baked into them.

But it's safe for the next 30 years or so. Hopefully we'll all be using 64-bit systems by then.
_______________________________________________

Cocoa-dev mailing list (Cocoa-dev@lists.apple.com)

Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com

Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to