Re: date_ge and time_ge

On Fri, 21 Jun 2002 juerg(dot)rietmann(at)pup(dot)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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr