SQL getdate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can anyone help me with getdate() to format mm/dd/yy at the table level? I
am using SQL Server 7.0.
Thank you,
 
This is an Access news group. Not sure why your question pertains to SQL
Server 7 and why you want to format a field at the table level.
 
can anyone help me with getdate() to format mm/dd/yy at the table
level? I am using SQL Server 7.0.
Click to expand...

There is no such thing as formats at the table level: there are only data
and constraints.

Fields in Access tabledefs have a format property, but this is only to
serve as a default for dropping controls onto forms and reports. It is no
part of the data model at all.

If you want to see dates formatted in a particular way in a table
datasheet (which is really unkind thing to do to your users, by the way),
then you need to do it in a view or a sp -- check out the T-SQL functions
CONVERT and CAST.

Hope that helps



Tim F
 
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 pass-through query, SQL-92 combining strings: '&' does not 4
Ato generated control number 1
Convert SQL Code to Use in Access Query for Dates 2
Why and I getting this error message, "This record has been changed by another user since you starte 3
Get a Date to show as a Date Format in Combo Box 3
Prob getting value from function 2
GUID default value 5
Dataset Designer setting defaultvalue for DateTime field ??? 0

Back
Top