Date/Time problem -((( - Mailing list pgsql-sql

From Boris
Subject Date/Time problem -(((
Date
Msg-id 7225221807.20001230013625@x-itec.de
Whole thread Raw
Responses Re: Date/Time problem -(((  (Kaare Rasmussen <kar@webline.dk>)
RE: Date/Time problem -(((  ("Francis Solomon" <francis@stellison.co.uk>)
List pgsql-sql
Hello

I am moving from MySQL to Postgres and while converting my sql code I
have a lot of problems with this construction:

($ze is current time - 300 secounds):

delete from onlineuser where datum < FROM_UNIXTIME($ze)

Is there any Date/Time function in PGSQL? I want as shown in this
example delete entries older than 300 secounds.

I postet to the list because I have found no solution in the
tutorials and search-engine (maybe searched with wrong words?)

It would be great if someone could help me / point me to the right
way...

--
Boris




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimization recommendations request
Next
From: Thomas SMETS
Date:
Subject: Re: Running a file