Date format in view -- sql server new users

sql server new users : Date format in view

SAC
11/15/2006 6:24:01 PM

I have a smalldate field show as yyyy-mm-dd mm:ss

I like it to show mm/dd/yy.

What can I do?

Thanks.

SAC
11/15/2006 6:56:19 PM

I'm using Ms Acces as a frontend and it was fine. When I open the view in
Access, the field looks like mm/dd/yy but the form does not.

????

Thanks.
[quoted text, click to view]

Hari Prasad
11/15/2006 10:14:16 PM

Hi,

Take a look into CONVERT Function...

Eg:-

Select convert(char(10),getdate(),101)

Thanks
Hari

[quoted text, click to view]

SAC
11/16/2006 4:57:46 PM

Thanks.

[quoted text, click to view]

Stu
11/16/2006 7:24:03 PM

An alternative would be to leave the date as a date in the view, and
alter the format of the form. The benefit is that you can still do
date/time operations without having to convert back to a date.

Stu

[quoted text, click to view]

TW Server
1/8/2007 9:21:21 AM

Thanks!
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

home · blog · groups

Questions? Comments? Contact the dn