Changes for Code from Oracle to Netezza.

select * from schema.tbale a where TO_CHAR(column,'YYYY-MM-DD') >= TO_CHAR(next_day(sysdate-14,'MON'),'YYYY-MM-DD')

select * from database..table a where a.column >= next_day(now()-14,'MON');

 select REPLACE(REPLACE(REPLACE(column,CHR(13),' '),CHR(9),' '),CHR(10),' ') from schema.table;

 select translate(column, chr(9)||chr(10)||chr(13),'') from database..table;

SYSTEM(ADMIN)=> select abs(-1);
 ABS
-----
   1
(1 row)

SYSTEM(ADMIN)=> select abs(-5.456);
  ABS
-------
 5.456
(1 row)

SYSTEM(ADMIN)=> select abs(-5.456);
  ABS
-------
 5.456
(1 row)

SYSTEM(ADMIN)=> select abs(-5.456);
  ABS
-------
 5.456
(1 row)

SYSTEM(ADMIN)=> select acos(.5);
      ACOS
-----------------
 1.0471975511966
(1 row)

SQL> select add_months(trunc(sysdate,'MM'),-1) from dual;

ADD_MONTHS(TRUNC(S
 ------------------
 01-Nov-11 00:00:00

ODM_EVENT(ADMIN)=> select add_months(date_trunc('MONTH', now()), -1);
 ADD_MONTHS
 ---------------------
 2011-11-01 00:00:00
 (1 row)

SQL> select add_months(trunc(sysdate,'MM'),-1) from dual;

ADD_MONTHS(TRUNC(S
 ------------------
 01-Nov-11 00:00:00

ODM_EVENT(ADMIN)=> select add_months(date_trunc('MONTH', now()), -1);
 ADD_MONTHS
 ---------------------
 2011-11-01 00:00:00
 (1 row)

SYSTEM(ADMIN)=> select ascii('^');
 ASCII
-------
    94
(1 row)

SQL> select asciistr('^') from dual;

A
-
^

SQL> select ceil(10.3) from dual;

CEIL(10.3)
----------
        11

SYSTEM(ADMIN)=> select ceil(10.3);
 CEIL
------
   11
(1 row)

SQL> create table n (id number);

Table created.

SQL> begin
  2    for i in 1 .. 10 loop
  3      insert into n values (i/10);
  4    end loop;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> commit;

SQL> select cos(id) from n order by id;

   COS(ID)
----------
.995004165
.980066578
.955336489
.921060994
.877582562
.825335615
.764842187
.696706709
.621609968
.540302306

10 rows selected.

SYSTEM(ADMIN)=> create table n (id float);
CREATE TABLE
SYSTEM(ADMIN)=> insert into n values (.1);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.2);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.3);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.4);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.5);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.6);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.7);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.8);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.9);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (1);
INSERT 0 1

SYSTEM(ADMIN)=> select id, cos(id) from n order by id;
 ID  |       COS
-----+------------------
 0.1 | 0.99500416527803
 0.2 | 0.98006657784124
 0.3 | 0.95533648912561
 0.4 | 0.92106099400289
 0.5 | 0.87758256189037
 0.6 | 0.82533561490968
 0.7 | 0.76484218728449
 0.8 | 0.69670670934717
 0.9 | 0.62160996827066
   1 | 0.54030230586814
(10 rows)

SQL> select level, decode(level, 1, 'One', 2, 'Two', 'Other') from dual connect by level < 4;

     LEVEL DECOD
---------- -----
         1 One
         2 Two
         3 Other

SYSTEM(ADMIN)=> create table t (id int1);
CREATE TABLE
SYSTEM(ADMIN)=> insert into t values (1);
INSERT 0 1
SYSTEM(ADMIN)=> insert into t values (2);
INSERT 0 1
SYSTEM(ADMIN)=> insert into t values (3);
INSERT 0 1
SYSTEM(ADMIN)=> select id, decode(id, 1, 'One', 2, 'Two', 'Other') from t;
 ID | DECODE
----+--------
  1 | One
  3 | Other
  2 | Two
(3 rows)

SQL> select floor(10.1) from dual;

FLOOR(10.1)
-----------
         10

SYSTEM(ADMIN)=> select floor(10.1);
 FLOOR
-------
    10
(1 row)

SQL> select initcap('hello') from dual;

INITC
-----
Hello

SYSTEM(ADMIN)=> select initcap('hello');
 INITCAP
---------
 Hello
(1 row)

SYSTEM(ADMIN)=> select instr('abcde','b');
 INSTR
-------
     2
(1 row)

SYSTEM(ADMIN)=> select instr('abcdea','a',3);
 INSTR
-------
     6
(1 row)

 select * from schema.table a where TO_CHAR(a.START_DT,'YYYY-MM-DD') BETWEEN
TO_CHAR(next_day(sysdate-21,'MON'),'YYYY-MM-DD') AND
TO_CHAR(next_day(sysdate-14,'SUN'),'YYYY-MM-DD');

select * from database..table a where a.START_DT BETWEEN
next_day(now()-21,'MON') AND
next_day(now()-14,'SUN');

SELECT item, nvl(sold, false) AS sold FROM sales;

SELECT item, nvl(desc, 'No Description') AS desc FROM stock;

SELECT item, nvl(price, 0) AS cost FROM stock;

SELECT item, nvl(sale_date, now()) AS sold FROM sales;

SYSTEM(ADMIN)=> create table s (id int2);
CREATE TABLE
SYSTEM(ADMIN)=> insert into s select -10 union select -1 union select 0 union select 1 union select 10;
INSERT 0 5
SYSTEM(ADMIN)=> select id, sign(id) from s order by id;
 ID  | SIGN
-----+------
 -10 |   -1
  -1 |   -1
   0 |    0
   1 |    1
  10 |    1
(5 rows)

SYSTEM(ADMIN)=> create table s (id float);
CREATE TABLE
SYSTEM(ADMIN)=> insert into s select -10 union select -1 union select 0 union select 1 union select 10;
INSERT 0 5
SYSTEM(ADMIN)=> select id, sign(id) from s order by id;
 ID  | SIGN
-----+------
 -10 |   -1
  -1 |   -1
   0 |    0
   1 |    1
  10 |    1
(5 rows)

SYSTEM(ADMIN)=> create table s (id double);
CREATE TABLE
SYSTEM(ADMIN)=> insert into s select -10 union select -1 union select 0 union select 1 union select 10;
INSERT 0 5
SYSTEM(ADMIN)=> select id, sign(id) from s order by id;
 ID  | SIGN
-----+------
 -10 |   -1
  -1 |   -1
   0 |    0
   1 |    1
  10 |    1
(5 rows)

SYSTEM(ADMIN)=> create table s (id int2);
CREATE TABLE
SYSTEM(ADMIN)=> insert into s select -10 union select -1 union select 0 union select 1 union select 10;
INSERT 0 5
SYSTEM(ADMIN)=> select id, sign(id) from s order by id;
 ID  | SIGN
-----+------
 -10 |   -1
  -1 |   -1
   0 |    0
   1 |    1
  10 |    1
(5 rows)

SQL> create table n (id number);

Table created.

SQL> begin
  2    for i in 1 .. 10 loop
  3      insert into n values (i/10);
  4    end loop;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> select sin(id) from n order by id;

   SIN(ID)
----------
.099833417
.198669331
.295520207
.389418342
.479425539
.564642473
.644217687
.717356091
 .78332691
.841470985

10 rows selected.

SYSTEM(ADMIN)=> create table n (id float);
CREATE TABLE
SYSTEM(ADMIN)=> insert into n values (.1);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.2);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.3);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.4);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.5);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.6);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.7);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.8);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (.9);
INSERT 0 1
SYSTEM(ADMIN)=> insert into n values (1);
INSERT 0 1
SYSTEM(ADMIN)=> select id, sin(id) from n order by id;
 ID  |        SIN
-----+-------------------
 0.1 | 0.099833416646828
 0.2 |  0.19866933079506
 0.3 |  0.29552020666134
 0.4 |  0.38941834230865
 0.5 |   0.4794255386042
 0.6 |  0.56464247339504
 0.7 |  0.64421768723769
 0.8 |  0.71735609089952
 0.9 |  0.78332690962748
   1 |   0.8414709848079
(10 rows)

SQL> select to_char(sysdate, 'YYYY') from dual;

TO_CH
-----
2011

SYSTEM(ADMIN)=> select extract(year from now());
 DATE_PART
-----------
      2011
(1 row)

SYSTEM(ADMIN)=> select extract(yr from now());
DATE_PART
-----------
     2011
(1 row)

SYSTEM(ADMIN)=> select extract(year from add_months(date(now()),-25000);
DATE_PART
-----------
      -72
(1 row)

SQL> select to_char(sysdate, 'SYYYY') from dual;

TO_CH
-----
 2011

SQL> select to_char(add_months(sysdate,-25000), 'YYYY') from dual;

TO_C
----
0072

SQL> select to_char(add_months(sysdate,-25000), 'SYYYY') from dual;

TO_CH
-----
-0072

SQL> select to_char(sysdate, 'YYY') from dual;

TO_
---
011

SQL> select to_char(sysdate, 'YY') from dual;

TO
--
11

SQL> select to_char(sysdate, 'Y') from dual;

T
-
1

SQL> select to_char(99887766.55443322, '99999999.99999999') from dual;

TO_CHAR(99887766.5
------------------
 99887766.55443322

SQL> select to_char(99887766.55443322, '99999999.999999') from dual;

TO_CHAR(99887766
----------------
 99887766.554433

SQL> select to_char(99887766.55443322, '9999999999.999999') from dual;

TO_CHAR(99887766.5
------------------
   99887766.554433

SQL> select to_char(99887766.55443322, '0099999999.999999') from dual;

TO_CHAR(99887766.5
------------------
 0099887766.554433

Cast your number to the required format, but be aware of casting to an inappropriate type

SYSTEM(ADMIN)=> select cast(99887766.55443322 as int8);
 ?COLUMN?
----------
 99887767
(1 row)

SYSTEM(ADMIN)=> select cast(99887766.55443322 as int4);
 ?COLUMN?
----------
 99887767
(1 row)

SYSTEM(ADMIN)=> select cast(99887766.55443322 as int2);
ERROR: pg_atoi: error reading "99887766.55443322": Numerical result out of range
SYSTEM(ADMIN)=> select cast(99887766.55443322 as float);
    ?COLUMN?
-----------------
 99887766.554433
(1 row)

SQL> select add_months(trunc(sysdate),-1) from dual;

ADD_MONTH
---------
15-NOV-11

Oracle truncates to the day if not specified. Netezza requires the precision at which to truncate.

SYSTEM(ADMIN)=> select add_months(date_trunc(now()), -1);
ERROR:  Function 'DATE_TRUNC(TIMESTAMP)' does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts

SYSTEM(ADMIN)=> select add_months(date_trunc('DAY', now()), -1);
     ADD_MONTHS
---------------------
 2011-11-15 00:00:00
(1 row)

SQL> select add_months(trunc(sysdate,'MM'),-1) from dual;
ADD_MONTHS(TRUNC(S
 ------------------
 01-Nov-11 00:00:00
ODM_EVENT(ADMIN)=> select add_months(date_trunc('MONTH', now()), -1);
 ADD_MONTHS
 ---------------------
 2011-11-01 00:00:00
 (1 row)

SYSTEM(ADMIN)=> select true or false;