Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle - Anfängerfrage zu Datentyp DATE

Re: Oracle - Anfängerfrage zu Datentyp DATE

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Fri, 25 Nov 2005 17:56:21 +0100
Message-ID: <dm7fnj$olk$1@news1.zdv.uni-mainz.de> 





Florian Melcher schrieb:



> INSERT INTO T1 (YEAR_MONTH, NR)


> SELECT '2005-07', A.NR


> FROM T2 A;



You have to use the to_date function.



INSERT INTO T1 (YEAR_MONTH, NR)



SELECT to_date('2005-07', 'yyyy-mm'), A.NR
FROM T2 A;


You can control the output in your query using the to_char function.



hth,


Moritz
Received on Fri Nov 25 2005 - 10:56:21 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US