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

Re: Help with casting timestamp column

From: Janet Borschowa <borschow(at)roguewave(dot)com>
To: 'Chris Hoover' <revoohc(at)sermonaudio(dot)com>,pgsql-odbc(at)postgresql(dot)org
Subject: Re: Help with casting timestamp column
Date: 2004-06-10 18:02:31
Message-ID: D486606E7AD20947BDB7E56862E04C39041CC4@cvo1.cvo.roguewave.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Check out the EXTRACT and date_part functions. See the PostgreSQL User's
Guide for more information.

-- Janet


> -----Original Message-----
> From: Chris Hoover [mailto:revoohc(at)sermonaudio(dot)com] 
> Sent: Thursday, June 10, 2004 10:38 AM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Help with casting timestamp column
> 
> 
> I need a bit of help.  I have a table full of database stats that are 
> all timestamped using the now() timestamp.  However, I need 
> to pull some 
> consolidated reports that are based upon hourly activiy.  Does anyone 
> know of a way to get a timestamp column to return as mm/dd/yyyy hh?
> 
> Thanks for any help,
> 
> chris
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 

pgsql-odbc by date

Next:From: Janet BorschowaDate: 2004-06-10 18:03:10
Subject: Re: Help with casting timestamp column
Previous:From: Chris GamacheDate: 2004-06-10 18:00:29
Subject: Re: Help with casting timestamp column

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