> -----Original Message----- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Saturday, February 28, 2004 6:57 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] time calculations > > > I also added the ability to put a time value in as the > modifier and shift the date by that amount. For example: > > SELECT datetime('2003-12-04 09:27:00', '00:01:21'); > 2003-12-04 09:28:21 >
That sounds convenient but potentially dangerous - does it understand leap years/seconds, for example? And various other pitfalls of date/time math? -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]