pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (2+ messages)

Message-ID: <Pine.LNX.4.44.0206211244140.18457-100000@matrix.gatewaynet.com>
Permalink:  ../Pine.LNX.4.44.0206211244140.18457-100000@matrix.gatewaynet.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.44.0206211244140.18457-100000@matrix.gatewaynet.com

 · 

reply

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