Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have date format like this
i need 2 fileds form the above field
year and month
how. anyon please help
Month(Timestamp#('17-Sep-2013 08:12:56', 'DD-MMM-YYYY hh:mm:ss'))
Year(Timestamp#('17-Sep-2013 08:12:56', 'DD-MMM-YYYY hh:mm:ss'))
=Year(Timestamp(CREATION_DATE,'DD-MMM-YYYY hh:mm:ss'))
=Month(Timestamp(CREATION_DATE,'DD-MMM-YYYY hh:mm:ss'))