Joined: 07 Jan 2002 Posts: 2 Location: Bern, Switzerland
ok, it's less complicated than I thought
DECLARE posix INTEGER;
SET posix = CAST (((CURRENT_DATE - DATE '1970-01-01') DAY) * 24 * 3600 AS INTEGER) + CAST(CURRENT_TIME - TIME '00:00:00') SECOND AS INTEGER);
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum