postgresql 拾遗

1. 从timestamp提取date和time

to extract date from coldate,

SELECT date(coldate) FROM mytable;


to extract time,doing time(coldate) will give an error instead,Fixed">
SELECT "time"(coldate) FROM mytable

another way

SELECT coldate::time FROM mytable

2.string to timestamp

to_timestamp(timestring,format)

to_timestamp('15:33:33','HH24:MI:SS)

select to_timestamp('2011-12-30 00:30:00','YYYY-MM-DD HH24:MI:SS')::timestamp without time zone;

3. 字符串连接

‘string1’ || ‘string2’

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!