PostgreSQL
select * from xxx limit 100;
ex. to_timestamp(hit_time_gmt) extract(epoch from log_date) extract(epoch from timestamp '2009-11-09')