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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diane - 10 Jan 2008 22:05 GMT

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

Reply to this Message

Douglas J. Steele - 10 Jan 2008 22:12 GMT

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.

Signature

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

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

Reply to this Message

Diane - 10 Jan 2008 22:26 GMT

Thanks for that

> 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.
>
> >I want to create a field for time and also for date but want to create it
> >in
> > SQL Access2007, Any ideas

Reply to this Message

Jeff Boyce - 10 Jan 2008 22:41 GMT

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

Regards

Jeff Boyce
Microsoft Office/Access MVP

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

Reply to this Message