Обсуждение: type conversion between text and timestamp

Поиск
Список
Период
Сортировка

type conversion between text and timestamp

От
"Alex Cheung Tin Ka"
Дата:
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