Re: TO_DATE() Function
From: Scott Mattes <smattes_at_erols.com>
Date: Fri, 17 Nov 2000 10:58:28 -0500
Message-ID: <8v3kh4$njj$1_at_bob.news.rcn.net>
Date: Fri, 17 Nov 2000 10:58:28 -0500
Message-ID: <8v3kh4$njj$1_at_bob.news.rcn.net>
I think 'YYYYQ' should be 'MM/DD/YYYY' as the mask for TO_DATE describes your input to the function (you may be confusing TO_DATE and TO_CHAR).
"Mike" <mike213_at_nospam.net> wrote in message
news:bd2R5.835$UJ.151032_at_nnrp2.sbc.net...
> I am trying to write a TO-DATE( ) I am creating a table using a select
> statement :
>
> create table newtable
> as
> select data1 newdataname1,
> data2 TO_DATE('01/01/1900', 'YYYYQ') newdataname2
>
> What is the correct syntax for this TO_DATE() function so that
> conversion is done for the year and quarter (YYYYQ) ?
>
> Thanks
>
>
Received on Fri Nov 17 2000 - 16:58:28 CET