on 06-03-2015 5:38 AM
Hi.
I am unable to extract Month from DateTime. I'm using oracle as DB.
I have tried to_char(to_date(DWD_PRODUCT_EOP.BUSINESS_DATE,'MM-dd-yyyy'),'MM') it is showing ORA-00911 invalid character error.
Can anyone help me please.
My actual date format is like: dd/MM/yyyy hh:mm:ss AM
I want to extract month from it.
Thanks in Advance,
Santhosh.
In UDT, use this:
EXTRACT(MONTH FROM DWD_PRODUCT_EOP.BUSINESS_DATE)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Right clicking on a date column in the data foundation should give you the option to extract the month automatically, can you try that?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.