From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: juerg.rietmann@pup.ch
Cc: pgsql-sql@postgresql.org
Subject: Re: date_ge and time_ge
Date: Fri, 21 Jun 2002 12:45:17 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0206211244140.18457-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <OF4DF396C2.7FB3E5DE-ONC1256BDF.003420C5-C1256BDF.0034B6F2@pup.ch>
On Fri, 21 Jun 2002 juerg.rietmann@pup.ch wrote:
> Hello
>
> I have a question regarding date_ge() and time_ge().
>
> This statement works :
>
> select * from userlog where date_ge(ul_timestamp, '20.06.2002')
>
>
> This statement doesn't work :
>
> select * from userlog where time_ge(ul_timestamp, '08:00:00')
>
See the large list of functions of pgsql.
Use date_part, castings, etc...
>
> Here are some records from userlog :
>
> (See attached file: userlog.htm)
>
> __________________________________________________
>
> PFISTER + PARTNER, SYSTEM - ENGINEERING AG
> Juerg Rietmann
> Grundstrasse 22a
> 6343 Rotkreuz
> Switzerland
>
> internet : www.pup.ch
> phone : +4141 790 4040
> fax : +4141 790 2545
> mobile : +4179 211 0315
> __________________________________________________
>
--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, juerg.rietmann@pup.ch
Subject: Re: date_ge and time_ge
In-Reply-To: <Pine.LNX.4.44.0206211244140.18457-100000@matrix.gatewaynet.com>
References: <OF4DF396C2.7FB3E5DE-ONC1256BDF.003420C5-C1256BDF.0034B6F2@pup.ch> <Pine.LNX.4.44.0206211244140.18457-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox