Home > mailing lists

type conversion between text and timestamp - Mailing list pgsql-general

From	Alex Cheung Tin Ka
Subject	type conversion between text and timestamp
Date	July 29, 2002 03:16:53
Msg-id	00f201c236b6$adc323b0$6a44a8c0@alexpc Whole thread Raw
List	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

From: Bruce Momjian
Date: 29 July 2002, 02:26:13
Subject: Re: Is this query possible in PostgreSQL ?

From: Tom Lane
Date: 29 July 2002, 05:17:45
Subject: Re: Is this query possible in PostgreSQL ?