Convert Getdate() into (dd/mm/yy) format 1

[outofservice]

-- Converts todays date into (dd/mm/yy) format without
-- the timestamp

-- declare @date as datetime datatype
-- set @date as todays date
-- convert todays date into dd/mm/yy format

DECLARE @date smalldatetime
SET @date = getdate()
SELECT CONVERT(char(12), GETDATE(), 3)
GO Lauryn Bradley
SQL Server DBA

 

[Witchy]

Hi there, this will help me a great deal as I need to produce a date field without the timestamp. Thanks.

W.