change date format

[Mike Hughes]

I'm running a query against a Oracle DB. There is a field in the DB which is called BATCH and the field content is displayed in a date format, MM/DD/YYYY.
What I want to know is there a way, when running my query to convert the MM/DD/YYYY (example 1/24/2011) to MMDDYYYY (example 01242011) ?

Thanks for the help. Mike

 

[jdraw]

You could try Format


Consider a field MyDate = #7/14/2011#

NewFormat = Format(myDate,"MMDDYYYY")

 

[Mike Hughes]

Nope didn't work. Thanks for the suggestion

 

[boblarson]

Nope didn't work. Thanks for the suggestion

When you say, "nope didn't work" what does that really mean? What happened? Did it explode? Did it throw a brick through your window?

But seriously, we need more information than "didn't work." We can't see what you see and so you have to describe to us what it is that happened when you used the suggestion. And how did you actually implement the suggestion? What was the SQL of the query?