SQL getdate

[Greg]

can anyone help me with getdate() to format mm/dd/yy at the table level? I
am using SQL Server 7.0.
Thank you,

 

[Duane Hookom]

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.

 

[Tim Ferguson]

can anyone help me with getdate() to format mm/dd/yy at the table
level? I am using SQL Server 7.0.

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