Postgres Pro
Downloads
Home   >   mailing lists

Formating Dates - Mailing list pgsql-novice

From Colin Gillespie
Subject Formating Dates
Date
Msg-id 20DA376D0C991745A4D5249F7BCD7A250D36D2@largo.campus.ncl.ac.uk
Whole thread Raw
Responses Re: Formating Dates
List pgsql-novice
Tree view 
Dear All,

I have table which has a column 'timestamp' and a default 'now()'. Using this method puts the date into table but
includesupto 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

pgsql-novice by date:

Previous
From: joe@tsolucio.com (Joe Bordes)
Date:
Subject: Re: how to test string against regular expression contained in postgresql database field?
Next
From: Tom Lane
Date:
Subject: Re: Help for MSSQL "Compute" equivalent in Postgres