Very Computer

I have a time date field which include time, I want to group by the day in
Access I would have written format([date],"dd/mmm/yyyy"). Is  there an
equivalent in sql.

Cheers

Frank

Please always post which version of SQL Server you are using. The "help"
files differ for each release of SQL Server. Assuming you are using SQL
Server 2000, check out the section "CAST and CONVERT" in the SQL Server 2000
Books Online. It sounds as it you probably want style 103 ...

select convert (char(10), getdate( ), 103)

----------------------------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Quote:> Hi, can anybody tell me or point me to the correct bit of the help file
for
> this problem.

> I have a time date field which include time, I want to group by the day in
> Access I would have written format([date],"dd/mmm/yyyy"). Is  there an
> equivalent in sql.

> Cheers

> Frank