Hi,

can anyone help me with my little decision about what SQL-Type to use, either a TIMESTAMP or, as I used to until now, UnixTimestamp = Long.

Mainly I use it for creation/changed dates of my records, as well as some start/ending date and time of a event table.

What are the pros and cons of either one?

I do not like the nasty syntax of SQL-TIMESTAMP, e.g. when accessing the db from php:

select timestamp '1970-01-01' + interval '953559481 seconds';

But I do like the verbosity of the raw data.

Any ideas, hints about this discussion?

Regards,

Alex