I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want to mess with
time zones, but it seems that postgres
Hello
2013/1/4 Kirk Wythers kirk.wyth...@gmail.com
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want to mess with
time zones, but it seems that postgres
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want to mess with
time zones, but it seems that postgres
On Sat, Jan 5, 2013 at 4:28 AM, Kirk Wythers wythe...@umn.edu wrote:
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I
On 1/4/2013 9:28 AM, Kirk Wythers wrote:
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
you need to give it some hints as to how to do that casting.
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp USING