get date in binary number format

Поиск
Список
Период
Сортировка
От Johnson, Shaunn
Тема get date in binary number format
Дата
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73FBD@snt452.corp.bcbsm.com
обсуждение исходный текст
Ответы Re: get date in binary number format  (Alvaro Herrera <alvherre@atentus.com>)
Список pgsql-general

Howdy:

Silly question time -

Is there a way to get the date and change
it into a binary number?

To explain:

One of my colleague suggested that we could start
doing our backups / dump of the database via the
'Tower of Hanoi' algorithm.

The algorithm to select backup number would be the
smallest non-zero place in binary representation of
the backup number (tape).

My thinking is that I could try to figure out a case
statement to get the backup date and from there get
a binary number (an anchor date from the beginning
of the year) unique to that backup dataset (or, tape).

Any suggestions?

Thanks!

-X

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Performance while loading data and indexing
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Performance while loading data and indexing