type conversion between text and timestamp

From: "Alex Cheung Tin Ka" <tkcheung(at)vtc(dot)edu(dot)hk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: type conversion between text and timestamp
Date: 2002-07-29 04:16:14
Message-ID: 00f201c236b6$adc323b0$6a44a8c0@alexpc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All,
I would like to know how to convert a text string to timestamp in pgsql 7.2:

e.g. "July 26, 2002 16:00" or "December 25, 2002 11:30"

I have use the to_timestamp('December 25, 2002 11:30', 'Month DD, YYYY HH24:MI') but seems not work.

Do you have any other suggestion on this ?

Alex

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-29 06:17:26 Re: Is this query possible in PostgreSQL ?
Previous Message Christopher Kings-Lynne 2002-07-29 03:51:25 Re: [GENERAL] Stats Collector