Postgres Pro
Downloads
Home   >   mailing lists

Getting timestamp without milliseconds - Mailing list pgsql-general

From Tadej Kanizar
Subject Getting timestamp without milliseconds
Date
Msg-id 203220676CB@sagit-server.com
Whole thread Raw
Responses Re: Getting timestamp without milliseconds  (John Sidney-Woollett <johnsw@wardbrook.com>)
Re: Getting timestamp without milliseconds  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Getting timestamp without milliseconds  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Tree view

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 L

Thanks.

 

Regards,

Tadej

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Monitoring PostgreSQL connections using cricket and
Next
From: John Sidney-Woollett
Date:
Subject: Re: Getting timestamp without milliseconds