Please help me.. problem in to_char

Поиск
Список
Период
Сортировка
От azah azah
Тема Please help me.. problem in to_char
Дата
Msg-id 235b1a2804072101335eda05fd@mail.gmail.com
обсуждение исходный текст
Ответы Re: Please help me.. problem in to_char
Re: Please help me.. problem in to_char
Список pgsql-sql
Hi, 
I want convert from mysql to postresql, previously
in mysql the code as below:

SELECT t2.id, t2.name, date_format(t1.created,\'%W %M %e, %Y - %r\') 

In postresql no date_format function, we need to use to_char function
but it still work because still need to put ::date such as
SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');

How can i put ::date beside t1.created to get the output?
Any idea??


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: surrogate key or not?
Следующее
От: sad
Дата:
Сообщение: Re: surrogate key or not?