Re: [GENERAL] Default 'timestamp' value on HP-UX running Postgresql6.3.2

Hello Sangeeta,

martedì, 29 settembre 98, you wrote:

SR> I am running postgres 6.3.2 on HP_UX 10.2. I have a field defined as
SR> type 'timestamp' and am using ISO datestyle. The default value shows
SR> up as the string constant 'epoch'. Is there any way of having the numeric
SR> value of '1970-01-01 00:00:00+00' returned instead??

SR> I appreciate any help! Thanks.
SR> -sr

I don't know if there's a more intelligent way to solve this problem
but I had the same problem and I solve this by my self by modifying
the file: postgresql-6.3.2/src/backend/utils/adt/timestamp.c and
re-install PostgreSQL.

.....
29 char zone[MAXDATELEN + 1],
30 *tzn = zone;
31
32 switch (timestamp)
33 {
34 /*remark the following 3 lines to have dates as '1970-01-01 00:00:00+00' instead of 'epoch'
35 case EPOCH_ABSTIME:
36 strcpy(buf, EPOCH);
37 break;
38 */
39 case INVALID_ABSTIME:
40 strcpy(buf, INVALID);
.....

I hope this help you
Jose'