I have table name called Team and I have name and DOJ in that table in oracle,

I have table name called Team and I have name and DOJ in
that table in oracle, when I retrive the table in
Informatica DOJ shows with date and time , I want want to
know is it possible to get only date(MMDDYYYY) in the date
data type,

Question Posted / rajeshreshi

3 Answers
7070 Views
CSC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / bk

TO_CHAR(DOJ_port, 'MMDDYYYY')

Is This Answer Correct ?

14 Yes

0 No

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / yashvi

You can use TRUNC function in exp transformation e.g
TRUNC(to_date(fieldname,'mmddyyyy')

Is This Answer Correct ?

6 Yes

0 No

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the ..

Answer / srinu

oracle support range
Jan 1, 1753 AD
to
Dec 31, 9999 AD

in informatica
The default date display format is
DY MON DD HH 24:MI:SS YYYY.
When you specify a date display format,
it displays in the test window. An invalid date display
format is marked invalid.

if u not able to Understand,,,,

Please send the Question Clearly,,,,srinu

Is This Answer Correct ?

3 Yes

7 No

Post New Answer