Journey with OBIEE
Friday, 6 March 2015
Contert "Date" datatype Varchar to Date
CAST
(
EVALUATE
(
'TO_CHAR(TO_DATE(%1,%2),%3)'
,
<<Date Column>>
,
'MM/DD/YYYY'
,
'DD/MON/YYYY'
)
AS
DATE
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment