amanojackun

PostgreSQL_Misc

PostgreSQL

  • 行数の制限：limit xxx 
    select * from xxx limit 100;
  • unix time <=> 日付変換
    • unix time => date: to_timestamp(unix_time)
    • date => unix time: extract(epoch from (timestamp)) 
      ex.
to_timestamp(hit_time_gmt)
extract(epoch from log_date)
extract(epoch from timestamp '2009-11-09')

最新の20件

2014-11-17 2014-11-04

今日の5件

  • counter: 207
  • today: 1
  • yesterday: 0
  • online: 2