Migrating from DB/2 6.1 to PostgreSQL 8.1.4,
The following work under DB/2, but I can find no analog in the
PostgreSQL documentation:
time('00:00:00') [there is to_date() and to_timestamp(), but no
to_time()?]
timestamp(u.date, u.time) [where u.date is of type DATE and u.time
is of type TIME]
As with any paradigm shift, I'm sure this will be embarrassingly simple,
but I've spent hours RTFMing to no avail.
Andy
begin:vcard
fn:Andrew T. Robinson, CISM, CISSP
n:Robinson;Andrew
org:NMI InfoSecurity Solutions
adr:;;145 Newbury Street Second Floor;Portland;ME;04101;USA
email;internet:atr@xxxxxxx
title:President
tel;work:207-780-6381 x226
tel;fax:207-780-6301
x-mozilla-html:TRUE
url:http://www.nmi.net
version:2.1
end:vcard
