Re: How to convert a text variable into a timestamp in postgreSQL?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Friday, June 26, 2015, litu16 <litumelendez@xxxxxxxxx> wrote:
> I know how to convert a text to timestamp in postgreSQL using
>
> *    SELECT to_timestamp('05 Dec 2000', 'DD Mon YYYY')*
>
> but how can I convert a text variable (inside a function) to timestamp??

Generally, just try casting it.

textvarname::date

David J.