Re: TO_DATE defaults to Current Month - Please Help!
From: Kim Ng <kimmng_at_eskimo.com>
Date: 1995/11/29
Message-ID: <DIsFv1.D08_at_eskimo.com>#1/1
Date: 1995/11/29
Message-ID: <DIsFv1.D08_at_eskimo.com>#1/1
Use a package function that returns a modified format with a fixed date and call it anywhere you need it.
For example, the function will be
Function fix_time (time_arg IN VARCHAR2) IS
- time_arg is in HH:MI:SS format
- year is defaulted to year 1900 for consistency return to_date ('01-01-1900' || date_val, 'MM-DD-YYYY HH:MI:SS');
Have fun,
Kim Ng Received on Wed Nov 29 1995 - 00:00:00 CET