get date in binary number format - Mailing list pgsql-general

From Johnson, Shaunn
Subject get date in binary number format
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C73FBD@snt452.corp.bcbsm.com
Whole thread Raw
Responses Re: get date in binary number format
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance while loading data and indexing
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing