Hi All,
I am trying to handle null in a Date (length 10) and timestamp (length 26) datatype columns in Modify Stage. I specified as follows:
Date1=handle_null(date2,'1111-11-11')
timestamp1=handle_null(timestamp2,'1111-11-11 11:11:11.111111').
This is not working. Any suggestions plz.
Null Handling Dates in Modify Stage
Moderators: chulett, rschirm, roy
Null Handling Dates in Modify Stage
Every person you meet knows something you don't, Learn from them.
-- H. Jackson Brown
-- H. Jackson Brown
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Try testing them one at a time and maybe put in there a string to date or string to timestamp function inside the null handler.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn