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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: timestamp to date and time column migration

  • From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
  • To: Bill Totman <totman(at)gmail(dot)com>
  • Cc: pgsql-novice(at)postgresql(dot)org
  • Subject: Re: timestamp to date and time column migration
  • Date: Sun, 29 Jul 2007 15:20:22 -0500
  • Message-id: <3C266204-07DE-4A49-AE88-614023C610EB@seespotcode.net> <text/plain>

On Jul 29, 2007, at 13:39 , Bill Totman wrote:
I created a table where I used a timestamp type column and after inserting 
about 300 entries into this table I would now rather have two separate
columns for that data: one for just the date and the other for just the time. 

Why? What problem are you trying to solve?

Michael Glaesemann
grzm seespotcode net
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group