Hi,
On Progrees database in "where" I want to examine full datetime date+time.
Please give me good advice how to do it.
Thank you
Piotr
example for MS SQL2008
select 1,'2000-01-02','11:00'
select id,max(convert(varchar(20), tdate + ' ' + ttime )) date
from #temp