Hi! I rather thought about retrieving and storing milliseconds in SQL. I mean, a SQL data type which is able to store milliseconds and a SQL function to return the current timestamp including milliseconds. I had no luck with CURRENT_TIMESTAMP for instance.
Thanks! Thomas > -----Original Message----- > From: Srebrenko Sehic [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 12, 2007 10:34 AM > To: [email protected] > Subject: Re: [sqlite] Milliseconds > > On 7/12/07, Steinmaurer Thomas <[EMAIL PROTECTED]> wrote: > > Hello, > > > > is there a way to retrieve and store the millisecond part of a > > (current) timestamp? > > If you're on a Unix-like system, have a look at gettimeofday > which returns: > > struct timeval { > long tv_sec; /* seconds since Jan. 1, 1970 */ > long tv_usec; /* and microseconds */ > }; > > -------------------------------------------------------------- > --------------- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------- > --------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
