How to write a procedure for a date which is in three different formats,and you

How to write a procedure for a date which is in three
different formats,and you want to load into datawarehouse in
any single date formate

Question Posted / guest

2 Answers
4804 Views
AHM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to write a procedure for a date which is in three different formats,and you want to load into d..

Answer / vaibhav bhandeo

Use to_date function in an expression. This will allow you
to change any date's format into other one.
Ex:
to_date('070903', 'yyyy/mm/dd') would return a date value
of 2003/07/09.
to_date('20020315', 'yyyy/mm/dd') would return a date value
of 2003/07/09.

Is This Answer Correct ?

1 Yes

1 No

How to write a procedure for a date which is in three different formats,and you want to load into d..

Answer / ravi

if u can write decode function
decode((true,Is_date(culm_name,MM/DD/YYYY HH:MM:SS AM'),
to_date(clum_name,'MM/DD/YYYY HH:MM:SS ')
sysdate)
u can write multipul date formats in is,to date functions
otherwise it will return sys date

Is This Answer Correct ?

0 Yes

0 No

Post New Answer