Обсуждение: date_ge and time_ge

Поиск
Список
Период
Сортировка

date_ge and time_ge

От
juerg.rietmann@pup.ch
Дата:
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')


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
__________________________________________________
Вложения

Re: date_ge and time_ge

От
Achilleus Mantzios
Дата:
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