Help

[wonderkid]

oracle db lo oka table lo transaction_date ani oka coloumn undhi,
andhulo date insert chesthey 01/01/10 ani insert avuthundhi,instead of 01/01/2010.

How do I insert 01/01/2010 (the full year)??

[wonderkid]

yeda sacchinra andharu[img]http://i415.photobucket.com/albums/pp236/Keefers_/Keefers_Funny%20Animals%202/25a0e01b.gif[/img]

[Joey_Tribbiani]

insert into db values(TO_DATE('02.11.2012', 'DD.MM.YYYY');

[aamerica_seenu]

ida ethike badalu google sey dorukuthadi...

datedi edo format code untadi 101, 102 atla...

google ni use chesuko man

[wonderkid]

[quote name='Joey_Tribbiani' timestamp='1351882854' post='1302732424']
insert into db values(TO_DATE('02.11.2012', 'DD.MM.YYYY');
[/quote]

aala kuda try chesa mama,
same result YEAR 12 ani insert avuthundhi,instead of 2012

[wonderkid]

[quote name='aamerica_seenu' timestamp='1351883028' post='1302732435']
ida ethike badalu google sey dorukuthadi...

datedi edo format code untadi 101, 102 atla...

google ni use chesuko man
[/quote]

already google lo try chesanu,confused
andhuke asking

[ds_anilb]

ela insert chesthunnav? manually or using ETL tool? ikkada post cheyyi ela insert chesthunnavo manual ayithe

[wonderkid]

[quote name='ds_anilb' timestamp='1351883772' post='1302732506']
ela insert chesthunnav? manually or using ETL tool? ikkada post cheyyi ela insert chesthunnavo manual ayithe
[/quote]
Thanks for the rply mama

nenu informatica practice chesthunna
so na system lo oracle 10g db undhi,
andhulo oka sample table with Transaction_date ane coloumn create chesa
aa db lo eela table create chesa

CREATE TABLE CUSTOMER
(
CUST_ID INT,
TRANSACTION_DATE DATE
);

INSERT INTO CUSTOMER
VALUES (1,'01/01/2010');

OUTCOME:1,01/01/10

[deals2buy]

[quote name='wonderkid' timestamp='1351884172' post='1302732554']
Thanks for the rply mama

nenu informatica practice chesthunna
so na system lo oracle 10g db undhi,
andhulo oka sample table with Transaction_date ane coloumn create chesa
aa db lo eela table create chesa

CREATE TABLE CUSTOMER
(
CUST_ID INT,
TRANSACTION_DATE DATE
);

INSERT INTO CUSTOMER
VALUES (1,'01/01/2010');

OUTCOME:1,01/01/10
[/quote]

paina cheppinattu insert cheyyatam ledu kada vayya..try that someone who told in previous posts

[chelsea]

Help

[wonderkid]

[quote name='deals2buy' timestamp='1351884254' post='1302732562']
paina cheppinattu insert cheyyatam ledu kada vayya..try that someone who told in previous posts
[/quote]

EELA KUDA TRY CHESA BHAYYA

INSERT INTO CUSTOMER
VALUES (1,[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](TO_DATE('02.11.2012', 'DD.MM.YYYY')[/background][/size][/font][/color]);

SAME OUTPUT: 1,01/01/10

[deals2buy]

[quote name='wonderkid' timestamp='1351884768' post='1302732622']
EELA KUDA TRY CHESA BHAYYA

INSERT INTO CUSTOMER
VALUES (1,[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](TO_DATE('02.11.2012', 'DD.MM.YYYY')[/background][/size][/font][/color]);

SAME OUTPUT: 1,01/01/10
[/quote]


r u sure? endukante TO_DATE format lo insert chesetappudu definite ga adi tesukuntundi..insert pakkana pettu..mamulaga ala SELECT query chesi chudu adi mundu

[wonderkid]

[quote name='deals2buy' timestamp='1351884868' post='1302732635']


r u sure? endukante TO_DATE format lo insert chesetappudu definite ga adi tesukuntundi..insert pakkana pettu..mamulaga ala SELECT query chesi chudu adi mundu
[/quote]

I am pretty sure bhayya,ala kuda try chesanu
still the same thing

[buri]

ee tool vadutunnav,,sql developer aa toad aa

konni sarlu date formatlu nuvvu settings lo marchali vastadi..

[wonderkid]

[img]http://gifs.gifbin.com/032010/1269259657_omg_cat.gif[/img]