On Wed, May 28, 2008 at 1:31 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote: > Another possibility would be to use the TIMESTAMP name for an integer > unix epoch timestamp, and JULIANDAY for the floating point julian day > number, giving five default value codes. > > Name Inserts > =================================================== > CURRENT_DATE string date > CURRENT_TIME string time > CURRENT_DATETIME string date and time > CURRENT_TIMESTAMP integer unix timestamp > CURRENT_JULIANDAY real julianday number How about CURRENT_EPOCH for unix timestamp? -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users