Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 2 columns datatext(datatype varchar2) and date_created(timestamp)
the sample data for the columns
datatext - apr-23-2011
date_created - 4/23/2011 1:56:19 PM
Now i want convert date_created format to datatext ..
How do i do that ?
Please Help...
i think something like this could help you
= left(monthname(date_created),3) &'-'&day(date_created)&'-'&year(date_created)
What about this:
= Text(Date(Date#([date_created]), 'MMM-DD-YYYY'))