webdb=# select '02:02:02'::time-'2 hours 10 minutes'::interval;
?column?
----------
23:52:02
>>이성한 님께서 쓰시길<<
:: 안녕하십니까..
::
:: 다음과 같은 함수는 잘 되는디
::
:: tms=>select date('2001-01-01') from test_1
::
:: date
:: ------------
:: 2001-01-01
:: 2001-01-01
:: 2001-01-01
:: 2001-01-01
:: (4 rows)
::
:: 다음과 같은 Time 함수가 처리 되지 않군요...
:: tms=> select time('02:02:02') from test_1;
:: ERROR: Bad timestamp external representation '02:02:02'
::
:: 문자를 TIME type으로 convert 처리하는 함수가 있나요...
::
::
|