[sf-perl] Perl's to_date() equivalent

Loo, Peter # PHX Peter.Loo at source.wolterskluwer.com
Fri Sep 1 15:23:24 PDT 2006


Netezza does support to_date(), but the problem is I need to compare
current row's date to the previous rows date.  I suppose I could do:

select a, b, c, d, e, f, rx_fill_dte - to_date(1980-01-01, 'YYYY-MM-DD')
from some_table where some_conditions; 

Then using the calculated column to do the math.


-----Original Message-----
From: Josh Berkus [mailto:josh at agliodbs.com] 
Sent: Friday, September 01, 2006 3:20 PM
To: sanfrancisco-pm at pm.org
Cc: Loo, Peter # PHX
Subject: Re: [sf-perl] Perl's to_date() equivalent


> The problem is that the database is Netezza.  Although Netezza will be

> coming out with its own internal language, equivalent to, PL/SQL, 4GL,

> etc..., it is currently not available.

But Netezza is based on PostgreSQL, where to_date() is a c-language
built-in.  Are you telling me that they don't support it?


Josh Berkus
PostgreSQL @ Sun
San Francisco

This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.

More information about the SanFrancisco-pm mailing list