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

今日の4件

  • counter: 129
  • today: 1
  • yesterday: 0
  • online: 1