(T-Sql)-Convert DateTime to Date 1

[markajem]

Sorry, syntax again.

Trying to convert a DateTime to display as a Date in a VIEW I am creating.

Data is:
[tt]
2006-07-15 00:00:00.000
[/tt]

Would like it to be:
[tt]
2006-07-15
[/tt]

Also would anyone know of a good link/s where I can go and find some of the syntax listing I need. I am green at this and usually refer back to old VIEW's I have written for hints as to what I am doing wrong.

Thanks

 

[SQLDenis]

One way
select replace(convert(varchar,getdate(),111),'/','-')

and another
select left(convert(varchar,getdate(),120),10)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[markajem]

Denise thanks, they both work nicely.

 

[SQLBill]

Best reference:

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
or online at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

Posting advice: FAQ481-4875

 

[unknown2006]

Thanks SqlBill

 

[unknown2006]

SqlBill that will be usefull 4 me 2

 

[SQLBill]

Glad to help you unknown2006.

-SQLBill

Posting advice: FAQ481-4875

 

[r937]

instead of

select left(convert(varchar,getdate(),120),10)

you could just say

select convert(varchar(10),getdate(),120)

r937.com | rudy.ca