Hi,
I got a Oracle database field "createddate', i want get year from this field.
i Tried: to_date(to_char(createddate,'yyyy'),'yyyy')
i laso tried: trunc(createddate,'yyyy')
also tried: to_date(substr(to_chart(createddate),7,11,)'yyyy')
but when i test in Webi, i got '1/1/11' what's the right syntext?
Thanks
Edited by: hiccup on Dec 8, 2011 6:55 PM