On 06/26/2015 11:41 AM, litu16 wrote:
I know how to convert a text to timestamp in postgreSQL using
*SELECT to_timestamp('05 Dec 2000', 'DD Mon ')*
but how can I convert a text variable (inside a function) to timestamp??
In my table (table_ebscb_spa_log04) "time" is a character varying
On Friday, June 26, 2015, litu16 wrote:
> I know how to convert a text to timestamp in postgreSQL using
>
> *SELECT to_timestamp('05 Dec 2000', 'DD Mon ')*
>
> but how can I convert a text variable (inside a function) to timestamp??
>
>
Generally, just try casting it.
textvarname::date
I know how to convert a text to timestamp in postgreSQL using
*SELECT to_timestamp('05 Dec 2000', 'DD Mon ')*
but how can I convert a text variable (inside a function) to timestamp??
In my table (table_ebscb_spa_log04) "time" is a character varying column, in
which I have placed a format