Re: [GENERAL] Unix timestamp , unix timestamp with microseconds

2004-05-21 Thread Richard Huxton
In. Martin Prášek wrote: I I read the documentation well (PG 7.3.3 ) , i see that there is not a native support for data type UNIX TIMESTAMP and "unix timestamp expressed as microseconds" ie there it is impossible to direct insert and select seconds_from _Epoch seconds_from _Epoch (pe

Re: [GENERAL] unix timestamp

2001-08-16 Thread Thomas Lockhart
> how can i use unix timestamp as a data type? You don't want to. Really. > i thought that the timestamp data type use the unix timestamp but > found out that it didnt.. :( Right. One second resolution and limited range was considered a problem. > do i need to use an int data type for holding