Coalesce with Timestamp,Nulls,and Concatenation

Поиск
Список
Период
Сортировка
От Pam Wampler
Тема Coalesce with Timestamp,Nulls,and Concatenation
Дата
Msg-id 2E4528861499D41199D200A0C9B15BC001551060@taylorwhite.com
обсуждение исходный текст
Ответы Re: Coalesce with Timestamp,Nulls,and Concatenation  (Andrew McMillan <andrew@catalyst.net.nz>)
Список pgsql-novice
can someone please give the correct syntax for a query that has a column
timestamp that allows nulls and
needs to be converted to a certain format and also needs to be concatenated
with commas

example:

select to_char(timestamp1,'YYYYMMDD
HH24:MI')||','||employee||','||to_char(timestamp2,'YYYYMMDD HH24:MI') from
employee;

How do I put the coalesce & also get the correct format and handle if the
timestamps are nulls to ""?

thanks

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Joshua b. Jore"
Дата:
Сообщение: Re: Pl/Pgsql function troubles: FOLLOW UP
Следующее
От: "pg sql"
Дата:
Сообщение: Re: [DOCS] Upgrading - How? - Administrator's Guide ??