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

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

I want to create a field for time and also for date but want to create it in
SQL Access2007, Any ideas
 
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.
 
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...
 
Sorry, I don't recognize that phrase...What do you mean by "SQL Access2007"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 + SQL Server 7
Add a "Counter" to a Form 10
Show Date Difference only in a certain range 1
Access2007 weird error (any suggestions) 2
How to apply different backcolors to a field 6
Open Form Button does not work going from Access2003 to Access 200 7
Acc2007 TreeView Display/Edit Mode 0
Datepicker issue after changing Windows' short date time format 5

Back
Top