Re: [GENERAL] hrs, mins and seconds do not appear with to_char

Поиск
Список
Период
Сортировка
От Peter Koukoulis
Тема Re: [GENERAL] hrs, mins and seconds do not appear with to_char
Дата
Msg-id CABpxA9jDza5nJBK6tNCmmSbvi4nJmvNOawKZXYYKZtTdOX=NUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] hrs, mins and seconds do not appear with to_char  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения

thanks. didn't realise they were different. I discovered the difference when using a MD5 comparison between the 2 databases in a C++ utility.
All  values were matching apart from dates.

Cheers
P

On Sun, 27 Aug 2017 at 21:35 Tom Lane <tgl@sss.pgh.pa.us> wrote:
Peter Koukoulis <pkoukoulis@gmail.com> writes:
> I am unsure as to why the hrs, mins and seconds do not appear for a date
> column.

Uh, because it's a date.

> When performing the exact same queries in Oracle, I get the full date
> formatted to "yyyymmddhh24miss", but cannot get the same for PostgreSQL,
> for example:

Oracle has a nonstandard notion of what "date" means, I believe.  You
probably want to use type "timestamp", and the to_timestamp() function,
in PG if you want behavior similar to what Oracle is doing.

https://www.postgresql.org/docs/current/static/datatype-datetime.html

                        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] hrs, mins and seconds do not appear with to_char
Следующее
От: Ron Johnson
Дата:
Сообщение: [GENERAL] Logging the fact that a log was shipped