Re: arbitrary date math

From: VT <vitti_at_hotmail.com>
Date: 29 Apr 1998 16:36:52 GMT
Message-ID: <01bd7359$75009d20$69da1ba1@vturchetti.infostrada.it>

When using to_date, you should:
either follow the default date format for your database (the default is DD-MON-YY)
or specify a format string [e.g. to_date('1999-12-31','YYYY-MM-DD')]

HTH Vittorio

Jason Williams <jbwilliams_at_westpac.com.au.Z> ha scritto nell'articolo <35475F95.744E4CD8_at_westpac.com.au.Z>...
> how can you put an arbitrary date in a decode function eg:
> ...
> decode(sign(expiry_date-'1999-12-32')...
> ...
Received on Wed Apr 29 1998 - 11:36:52 CDT