構文

TO_DATE( 
string [, 
format] )

戻り値

例

TO_DATE( DATE_PROMISED, 'MM/DD/YY' )

DATE_PROMISED

RETURN VALUE

'01/22/98'

Jan 22 1998 00:00:00

'05/03/98'

May 3 1998 00:00:00

'11/10/98'

Nov 10 1998 00:00:00

'10/19/98'

Oct 19 1998 00:00:00

NULL

NULL

TO_DATE( DATE_PROMISED, 'MON DD YYYY HH12:MI:SSAM' )

DATE_PROMISED

RETURN VALUE

'Jan 22 1998 02:14:56PM'

Jan 22 1998 02:14:56PM

'Mar 15 1998 11:11:11AM'

Mar 15 1998 11:11:11AM

'Jun 18 1998 10:10:10PM'

Jun 18 1998 10:10:10PM

'October 19 1998'

Error. Integration Service skips this row.

NULL

NULL

TO_DATE (SHIP_DATE_MJD_STR, 'J')

SHIP_DATE_MJD_STR

RETURN_VALUE

'2451544'

Dec 31 1999 00:00:00.000000000

'2415021'

Jan 1 1900 00:00:00.000000000

TO_DATE( DATE_STR, 'MM/DD/RR')

DATE_STR

RETURN VALUE

'04/01/98'

04/01/1998 00:00:00.000000000

'08/17/05'

08/17/2005 00:00:00.000000000

TO_DATE( DATE_STR, 'MM/DD/YY')

DATE_STR

RETURN VALUE

'04/01/98'

04/01/1998 00:00:00.000000000

'08/17/05'

08/17/1905 00:00:00.000000000

TO_DATE( DATE_STR, 'MM/DD/Y')

DATE_STR

RETURN VALUE

'04/01/8'

04/01/1998 00:00:00.000000000

'08/17/5'

08/17/1995 00:00:00.000000000

TO_DATE( DATE_STR, 'MM/DD/YYY')

DATE_STR

RETURN VALUE

'04/01/998'

04/01/1998 00:00:00.000000000

'08/17/995'

08/17/1995 00:00:00.000000000

TO_DATE( DATE_STR, 'MM/DD/YYYY SSSSS')

DATE_STR

RETURN_VALUE

'12/31/1999 3783'

12/31/1999 01:02:03

'09/15/1996 86399'

09/15/1996 23:59:59

DECODE( TRUE,

 --test first format
   IS_DATE( CLOSE_DATE,'MM/DD/YYYY HH24:MI:SS' ),

 --if true, convert to date
      TO_DATE( CLOSE_DATE,'MM/DD/YYYY HH24:MI:SS' ),

 --test second format; if true, convert to date
   IS_DATE( CLOSE_DATE,'MM/DD/YYYY'), TO_DATE( CLOSE_DATE,'MM/DD/YYYY' ),

 --test third format; if true, convert to date
   IS_DATE( CLOSE_DATE,'MON DD YYYY'), TO_DATE( CLOSE_DATE,'MON DD YYYY'),

 --if none of the above
   ERROR( 'NOT A VALID DATE') )

TO_CHAR( TO_DATE( numeric_month, 'MM' ), 'MONTH' )