Re: Re: epoch to show millseconds
От | Mitch Vincent |
---|---|
Тема | Re: Re: epoch to show millseconds |
Дата | |
Msg-id | 016f01c113ac$47ab0ee0$1251000a@Mitch обсуждение исходный текст |
Ответ на | Re: epoch to show millseconds (mars g miro <mars@cannoncreek.com>) |
Список | pgsql-general |
Remember that epoch is a number of seconds, plain and simple so you can't get milliseconds from epoch, unless you wanted to carry zeros out to infinity :-) Good luck! -Mitch ----- Original Message ----- From: "mars g miro" <mars@cannoncreek.com> To: "Tom Lane" <tgl@sss.pgh.pa.us>; <pgsql-sql@postgresql.org>; <pgsql-general@postgresql.org> Sent: Tuesday, July 17, 2001 9:22 PM Subject: [GENERAL] Re: epoch to show millseconds > On Wednesday 18 July 2001 09:32, "Tom Lane" <tgl@sss.pgh.pa.us> wrote: > > > > Mars G Miro <mars@cannoncreek.com> writes: > > > how do I make it accurate up to milliseconds value? > > > > You don't. current_timestamp depends on the time() system call, > > which only returns a number accurate to one second. > > > > Well, I managed to have a workaround for it by: > punkdb=# select date_part('epoch', current_timestamp) || > trim(to_char(date_part('millisecond', timeofday()::timestamp),'999')); > > ?column? > -------------- > 995418886281 > (1 row) > > > > There is a higher-precision current time function in 7.1, but I > > forget the details ... see the docs. IIRC it existed but was > > buggy in 7.0, so you'll need to update. > > > > This is on 7.0.3 > > > regards, tom lane > > My sole purpose is to generate a primary key, w/c I believe is sufficient and > unique enough to avoid double records (or errors that an existing record of > the same epoch exist, if it's only up to the second). > > Thanks, for the response though, I really appreciate it ;-) > > > > cheers > mars > -- > "I gained nothing at all from Supreme Enlightenment, and for that very > reason it is called Supreme Enlightenment." > -- Gotama Buddha > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
В списке pgsql-general по дате отправления: