Re: Extract Function

On Fri, 19 Mar 2004, Derrick Betts wrote:

> I am trying to use the EXTRACT function in pl/pgsql and running into a problem.
>
> This is the command:
>
> SELECT EXTRACT(EPOCH FROM TIMESTAMP variable_name) INTO Temp;
>
> The variable_name is of type text (I've also tried it as type
> timestamp), but the parser breaks when it attempts to perform this
> function.  It works great when I substitute the variable_name with
> '2004-1-10 00:00:00' , however, when I use a variable, it doesn't.

TIMESTAMP <foo> is meant for timestamp literals.  If you want to
convert a value from one type to another, you probably want something
like CAST(variable_name AS TIMESTAMP)