Hi all,
Coming from mysql, and about to lose my mind.
Dealing with yet another cms system here...
taking one field as text value and running it through to_date()...
works like a charm.
taking another text field which holds a char, casting to int4...
then trying to add the two to get another date as in:
select to_date( textfield1, 'MM-DD-YYYY') as startDate, CAST
( textfield2, int4) as duration, startDate + duration as endDate.
this doesnt work, and I can find anything concrete anywhere on it,
just sparse entries in the postgres manual posted pre 2000. = /
ive gone through several variations on intervals and they fail as well.
its not rocket science, but im losing my mind trying to do that
should take a few seconds tops.
thanks in advance,
bob
btw db version is 7.3 and i will have to get it to work in 7.4 as well.