... until the collector arrives ...

This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)

2005-02-07

Oracle Dates

Oracle seems to think that SYSDATE is some strange species of date.  If you try a statement like this:

select case when some_flag=1 then sysdate else some_date end from some_table;

Then Oracle will complain with 'ORA-00932: inconsistent datatypes'. The workaround is to use cast(sysdate as date).

Blog Archive