Thread

1. Date help

   Brian C. Doyle <bcdoyle@mindspring.com> — 2001-01-15T18:19:31Z

   What date field would i want to use for "Mon, 15 Jan 2001 11:10:28 
   -0500"  that is how I get the data and would like to keep it as close to 
   that as possible???
   
   
   
   

2. Re: Date help

   Anthony E . Greene <agreene@pobox.com> — 2001-01-15T21:26:09Z

   On Mon, 15 Jan 2001 13:19:31 Brian C. Doyle wrote:
   >What date field would i want to use for "Mon, 15 Jan 2001 11:10:28 
   >-0500"  that is how I get the data and would like to keep it as close to 
   >that as possible???
   
   The "datetime" datatype stores the data as needed. To keep the output close
   to what you input, use:
   
     set DateStyle to 'Postgres';
   
   That outputs dates like this:  Tue Jan 09 06:12:11 2001 EST
   
   Use "\h set" to see the available date styles.
   
   Tony
   -- 
   Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
   PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
   Chat:  AOL/Yahoo: TonyG05    ICQ: 91183266
   Linux. The choice of a GNU Generation. <http://www.linux.org/>