Getting timestamp without milliseconds

From: "Tadej Kanizar" <Tadej(dot)Kanizar(at)sagit-server(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Getting timestamp without milliseconds
Date: 2006-01-05 16:04:16
Message-ID: 203220676CB@sagit-server.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I've got a timestamp field.. and it returns sth like "2006-01-04
21:33:17.156". How can I get the same result, just without the .156? I've
looked at date/time formatting functions, etc, but couldn't find a straight
way to do this :-(

Thanks.

Regards,

Tadej

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2006-01-05 16:16:35 Re: Getting timestamp without milliseconds
Previous Message Steve Crawford 2006-01-05 16:03:07 Re: Monitoring PostgreSQL connections using cricket and