actally i have UNIX time and that is in *1153222974* format. and i m using
select to_timestamp(1153222974); http://www.postgresql.org/docs/8.1/static/functions-formatting.html if you're on 8.1. HTH. Ben K. Developer http://benix.tamu.edu ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
