How do i set sql to show the date and time format in a field

D

Diane

I want to create a field for time and also for date but want to create it in
SQL Access2007, Any ideas
 
D

Douglas J. Steele

Are you saying that you want to use DDL (Data Definition Language) to create
the field? As far as I know, you can't set its format using DDL.
 
D

Diane

Thanks for that

Douglas J. Steele said:
Are you saying that you want to use DDL (Data Definition Language) to create
the field? As far as I know, you can't set its format using DDL.
Click to expand...
 
J

Jeff Boyce

Sorry, I don't recognize that phrase...What do you mean by "SQL Access2007"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top