On Tue, Oct 23, 2018 at 3:05 PM, Hellmuth Vargas <hivs77@xxxxxxxxx> wrote: ... >> Then use current_date: >> >> where ts >= current_date >> and ts < current_date + 1 > > this is equally valid? > > where ts >= current_date It'is not as the problem was stated. Although ts defaulted to now(), and it is probably defaulted, nothing prohibits him from inserting timestamps in the future. Also, I'll point the table used in the sample ( bigserial+timestamp) does not seem like a real one and the "timestamps in today" pattern is commonly used in calendaring applications, which usually insert appointments in the future and recover this way to print "todays schedule". Francisco Olarte.
