HELLO, I encounter an error if i use NULLIF with timestamp with time zone. eq. dbtime=nullif(mytime,'')
i want to null the value of field DBTIME if the variable mytime=" " DBTIME ="timestamp with time zone" datatype error: column DBTIME is of type timestamp with time zone but expression is of type text. What should i do? Thanks in advance... -- Gera Mel E. Handumon Application Programmer PaySoft Solutions, Inc. ----------------------------------------------------------------- "Share your knowledge. It's a way to achieve immortality" - Dalai Lama
