Re: [GENERAL] Timestamp precission question

2008-11-11 Thread Vaclav TVRDIK
olumn is defined in such way: CREATE_DATtimestampnot null default now(), but in my opinion the value is already stored in the column and then my query should return same texts because they do display the same value in the same format, shouldn't they ? Thank you Vaclav Tvrdik -- Se

[GENERAL] Timestamp precission question

2008-11-11 Thread Vaclav TVRDIK
microsecconds value, maybe rounding error ?). Could please somebody tell me what is the reason ? I have tried to find some info about it on web but without success. Thanks in advance Vaclav TVRDIK WoC=> SELECT to_char(create_dat, '-DD-MM HH24:MI:SS:US'), create_dat::text WoC-> from co