Posted by Jens on 03/14/06 16:07

No problem, look at the CONVERT function for a specific format you want
to extract. I prefer using the ISO one, though its good for ordering
and international.

CONVERT(VARCHAR(10),GETDATE(),112)

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---

• Next in forum: 2005 Database Mirroring & Witness
• Prev in forum: convert a datatype
• Thread view: Re: convert a datatype

[Reply to this message]