"Charly Caulet" <[EMAIL PROTECTED]> wrote:
>
> But when strftime doesn't seem to work :
> >INSERT INTO contrat(tstp) VALUES("1184834152");
> >SELECT * FROM contrat;
> 1|1184834152|16-08-3239253
> -------------------------------------------------
>
SQLite uses the julian day number, not seconds since
1970. My guess is that julian day number 1184834152
really is sometime in the year 3239253...
If you say
strftime('%d-%m-%Y', new.tstp, 'unixepoch')
the extra "unixepoch" argument will convert from
seconds since 1970 into julian day number for you
and solve your problem.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
