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: 20DA376D0C991745A4D5249F7BCD7A250D36D2@largo.campus.ncl.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Thanks

Colin

Responses

Browse pgsql-novice by date

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