Re: [GENERAL] timestamp and calculations.

2006-07-20 Thread Sven Willenberger
On Thu, 2006-07-20 at 11:57 +0200, Andreas Kretschmer wrote: > Thor Tall <[EMAIL PROTECTED]> schrieb: > > > Hi, > > > > I am new to postgres sql and have a problem with an > > sql statement which I hope you can help me with. > > > > I want to do some calculation on the result of a > > query. > >

Re: [GENERAL] timestamp and calculations.

2006-07-20 Thread Andreas Kretschmer
Thor Tall <[EMAIL PROTECTED]> schrieb: > Hi, > > I am new to postgres sql and have a problem with an > sql statement which I hope you can help me with. > > I want to do some calculation on the result of a > query. > > I have a table tb_test which contains a timestamp > column my_timestamp. > >

[GENERAL] timestamp and calculations.

2006-07-20 Thread Thor Tall
Hi, I am new to postgres sql and have a problem with an sql statement which I hope you can help me with. I want to do some calculation on the result of a query. I have a table tb_test which contains a timestamp column my_timestamp. My sql statement should display my_timestamp as "00", "20", "4