Setting date format in SQL query

[lopster10]

Hi Guys,

I have a simple Create table query but I need to set a field to a specific date format, that being dd mm yyyy.

If I just leave it as default "Date" then it returns as dd/mm/yy.

How can I set the data format within the Create table query string for that field? Or do I need to achieve this a different way?

Any help appreciated

 

[SkipVought]

Hi,

faq68-5827.

Since Date Serial values are NUMBERS, the "format" is irelevant except for display purposes.

Please post your query SQL to show your syntax.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[RoyVidar]

You can't set such format through DDL, you would need code.

But, as stated by SkipVought, format is for display purposes, not storage.

Here's a recent thread in one of the Access fora that might help, if "you insist" ;-) thread705-1528476

Roy-Vidar