Skip site navigation (1) Skip section navigation (2)

Formating Dates

From: "Colin Gillespie" <C(dot)Gillespie(at)newcastle(dot)ac(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Formating Dates
Date: 2004-03-30 09:08:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Dear All,

I have table which has a column 'timestamp' and a default 'now()'. Using this method puts the date into table but includes upto milliseconds. How do I view only the date and time (not including seconds). 

For example  2004-03-30 09:46:36.904064 would become 2004-03-30 09:46:36




pgsql-novice by date

Next:From: Oliver FrommeDate: 2004-03-30 10:38:17
Subject: Re: Images in Database
Previous:From: Noel FauxDate: 2004-03-30 06:45:23
Subject: database replication Master - slave model

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group