Re: timestamp value
От | Ivan Horvath |
---|---|
Тема | Re: timestamp value |
Дата | |
Msg-id | 20020304103846.14727.qmail@web14702.mail.yahoo.com обсуждение исходный текст |
Ответ на | Re: timestamp value (Oliver Elphick <olly@lfix.co.uk>) |
Список | pgsql-novice |
thank you very much it is working! Ivan --- Oliver Elphick <olly@lfix.co.uk> wrote: > On Mon, 2002-03-04 at 09:49, Ivan Horvath wrote: > > Oliver, > > > > then what can i do -regarding timestamp- if i need > to > > create such a routine, so called > "batch-processing", > > which writes data to a table, or more tables at > the > > same time? > > how can i ask the real timestamp value within a > stored > > procedure? > > > 1. Do you really need to distinguish > _within_a_transaction_? > > 2. Use timeofday()::TIMESTAMP > (It's in the docs at User manual 4.8.3) > > -- > Oliver Elphick > Oliver.Elphick@lfix.co.uk > Isle of Wight > http://www.lfix.co.uk/oliver > GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A > 614D 4C34 3E1D 0C1C > > "Give, and it will be given to you. A good > measure, > pressed down, taken together and running over, > > will be poured into your lap. For with the > same > measure that you use, it will be measured to > you." Luke 6:38 > __________________________________________________ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com
В списке pgsql-novice по дате отправления: