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