Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
WHERE clause with timestamp data type
- From: Chirag Patel <patelc75(at)yahoo(dot)com>
- To: PostgreSQL Novice List <pgsql-novice(at)postgresql(dot)org>
- Subject: WHERE clause with timestamp data type
- Date: Sun, 26 Aug 2007 21:49:29 -0700 (PDT)
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
- Follow-Ups:
- Re: WHERE clause with timestamp data type
- From: A. Kretschmer
- Re: WHERE clause with timestamp data type
- From: Tom Lane
- Re: WHERE clause with timestamp data type
- Prev by Date: Re: How to import a csv
- Next by Date: Re: WHERE clause with timestamp data type
- Previous by thread: How to import a csv
- Next by thread: Re: WHERE clause with timestamp data type
- Indexes: