WHERE clause with timestamp data type

Поиск
Список
Период
Сортировка
От Chirag Patel
Тема WHERE clause with timestamp data type
Дата
Msg-id 588009.30252.qm@web52811.mail.re2.yahoo.com
обсуждение исходный текст
Ответы Re: WHERE clause with timestamp data type
Re: WHERE clause with timestamp data type
Список pgsql-novice
The following command works great,
SELECT AVG(column) FROM table WHERE timestamp > 2007-08-23;

But when I try it with finer resolution (hour, minutes, seconds) like this, I get a syntax error
SELECT AVG(heartrate) FROM heartrates WHERE timestamp > 2007-08-23 19:48:09;

Do I need to convert from string format to total number of seconds? Any ideas on how to get this work?

Thanks!
Chirag




В списке pgsql-novice по дате отправления: