Re: Getting only Date




"Paulo" <eris_paulo@xxxxxxxxxxxx> escreveu na mensagem
news:%23q$QtWx0JHA.1432@xxxxxxxxxxxxxxxxxxxxxxx
Hi, how do I only get the current Dte (yyyy/mm/dd) on SQL 2000?

tried below but no success... many thanks!
SELECT CONVERT (Date, GetDate())


On the sql below, can something be done to ensure the Year will return 4
digits, Month with 2 and Day with 2...? Just to use the standard: '20090512'
select Cast(Year(GetDate()) as VarChar) + Cast(Month(GetDate()) as VarChar)
+ Cast(Day(GetDate()) as VarChar)

Many Thanks


.