What steps will reproduce the problem? 1.Create table 'foo' with colume name 'time_test' type 'time' only.

2. insert time data using raw sql (from psql,etc.) no sequel/ruby involved: INSERT INTO foo (time_test) values ('16:02:23'); insert as many data as you'd like if you want

3. after connecting stuff, do soemthing like this DB[:foo].each do|row| puts row[:time_test]
   end

What is the expected output? What do you see instead? EXPECTED: 16:02:23 RESULT: Sat Dec 25 16:02:23 +0700 2010

The date is the current local date and +0700 is my local time zone.

What version of the product are you using? On what operating system? Postgresql 9.0.1 , pg 0.10.0, sequel 3.18.0, ruby enterprise edition 1.8.7
on Linux zenwalk 6.4

Please provide any additional information below. In short, I expect time only without date but sequel give me full timestamp. The format is similiar like you run 'date' command in Linux.

Ruby doesn't have a built in object that stores a time without a date. Database time columns use Ruby's Time type, which also stores a date, generally using the current date. This is expected behavior.