HOW: formatting date in sql

[Zolix2010]

hi,
i got an Access db and i want to make an SQL query
that retrieve a date field and but with this format (mm/yyyy).
how do i do it in SQL (of access db)?
anyone?

[NigelQ]

You could try:

SELECT Format(Now(), "mm") + '/' + Format(Now(), "yyyy") AS MyDate;

...and substitute your date column for the calls to Now()

Hope this helps,

- Nigel

[pjb007]

Useful code,

I used it to get a date in the form mm/dd/yy (I am in UK but needed to do this)

Is there a way to get a date to show like this
Thursday October 14, 2004 (note just one , ) also is there an option to add the two letters after the date ie 14th, 2nd etc. I can display the number but not the bit after.

EDIT1
I would also like to have the date as shown above all in one coloum I have done this and it works, but can I have tabs so that the Day, Date, Month, ,and year line up.

Also can you add time in Access I get 00:00 for all using HH:nn