TO_DATE() Function
From: Mike <mike213_at_nospam.net>
Date: Thu, 16 Nov 2000 22:10:30 -0600
Message-ID: <bd2R5.835$UJ.151032_at_nnrp2.sbc.net>
Date: Thu, 16 Nov 2000 22:10:30 -0600
Message-ID: <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
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) ?
as
select data1 newdataname1,
Thanks Received on Fri Nov 17 2000 - 05:10:30 CET