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


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

Original text of this message