>I only need the date portion of GetDate() as I want to insert today's date into a table. What's the best way to do this?
>
>Thanks
Where you want to insert it?
What type is that field?
If the field is date type you don't need to do anything:
DECLARE @Test TABLE (fld Date)
INSERT INTO @Test VALUES (GETDATE())
SELECT * FROM @Test
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.