type conversion between text and timestamp

Started by Alex Cheung Tin Kaover 23 years ago1 messagesgeneral
Jump to latest
#1Alex Cheung Tin Ka
tkcheung@vtc.edu.hk

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