I didn't understood modifiers utility, reading this page (http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions). Thank you Igor and Richard for explainations and help.
> I'm not sure what 1184834152 is supposed to represent, It is an UNIX timestamp (number of seconds since 1970). > You probably want > > strftime('%d-%m-%Y', new.tstp, 'unixepoch') It's exactly what I need. Charly CAULET ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------