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

's Computer Specifications

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

's Computer Specifications

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Diane" <(E-Mail Removed)> wrote in message
news:766FEC46-3A74-4901-929C-(E-Mail Removed)...
>I want to create a field for time and also for date but want to create it
>in
> SQL Access2007, Any ideas

's Computer Specifications

Thanks for that

"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Diane" <(E-Mail Removed)> wrote in message
> news:766FEC46-3A74-4901-929C-(E-Mail Removed)...
> >I want to create a field for time and also for date but want to create it
> >in
> > SQL Access2007, Any ideas
>
>
>

's Computer Specifications

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Diane" <(E-Mail Removed)> wrote in message
news:766FEC46-3A74-4901-929C-(E-Mail Removed)...
>I want to create a field for time and also for date but want to create it
>in
> SQL Access2007, Any ideas

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to show imported field as date format DD-MMM-YY	ttp	Microsoft Access External Data	2	6th Jan 2009 10:12 PM
The same Date / Time field contains time in different format after import from text file	Evgeniy	Microsoft Access	4	20th Jun 2008 02:04 PM
Format Date and Time to show Military Time	=?Utf-8?B?QWxhbkZE?=	Microsoft Word Document Management	2	22nd Sep 2006 10:44 PM
Don't want time to show up in date field	=?Utf-8?B?SmVkaTAyMjY5NA==?=	Microsoft Access VBA Modules	1	2nd Jun 2005 11:10 PM
Export Outlook date field as date/time format to Access database	=?Utf-8?B?QmVja3k=?=	Microsoft Outlook Discussion	0	2nd Dec 2004 02:49 PM