Help

[aXXo]

[quote name='wonderkid' timestamp='1351886209' post='1302732812']
[img]http://gifs.gifbin.com/032010/1269259657_omg_cat.gif[/img]
[/quote]

nuvvu which tool use chestunnavu to view output?
daani lo date format marchu ade vastadi
oracle command promp to try checy exact ga output kanipistidi

[ChampakDas]

arey oracle inert format vayya adhi...if you want to retrieve in the foramt that you want..
do like this
SELECT TO_CHAR(COLUMN NAME, 'YYYY/MM/DD') AS COLUMN FROM TABLE
aa string format nee istam vachinatu marchuko let me know

[wonderkid]

[quote name='ChampakDas' timestamp='1351886563' post='1302732868']
arey oracle inert format vayya adhi...if you want to retrieve in the foramt that you want..
do like this
SELECT TO_CHAR(COLUMN NAME, 'YYYY/MM/DD') AS COLUMN FROM TABLE
aa string format nee istam vachinatu marchuko let me know
[/quote]

kadhu bhayya
Informatica designer lo ee value ni compare chesi output eevvali
so informatica format emo 01/01/2010 ani undhi
ee DB value emo 01/01/10 ani undhi,so naa informatica designer ee DB value pick chesukovatledhu and it returns error

[ChampakDas]

Informatica ninchi ela pick chestunnavo aa query ekada padeyi

[wonderkid]

SETMAXVAR(TRANS_DATE,$$MAPPINGVARIABLE)

IKKADA TRANS_DATE=01/01/10,

$$MAPPINGVARIABLE=01/01/2009

[ChampakDas]

TRANS_DATE ni type cast cheyi as I told above..

[CheGuevara]

e paameter em set chesidi undi nee DB lo... nls_date_format

use this command:

SQL> show parameter nls_date_format

[Chakram12]

LTT

[wonderkid]

[quote name='CheGuevara' timestamp='1351890869' post='1302733309']
e paameter em set chesidi undi nee DB lo... nls_date_format

use this command:

SQL> show parameter nls_date_format
[/quote]

TYPE:STRING
VALUE: EM LEDHU BHAYYA,BLANK

[wonderkid]

[quote name='ChampakDas' timestamp='1351889699' post='1302733201']
TRANS_DATE ni type cast cheyi as I told above..
[/quote]

chesanu bhayya,
Validate chesthey INVALID ani vasthundhi

[ChampakDas]

aa insert okasari ela try cheyi
INSERT INTO CUSTOMER VALUES (1, DATE '2010-01-01')
[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]

[pavan_613]