Re: Getting only Date

"Paulo" <eris_paulo@xxxxxxxxxxxx> escreveu na mensagem
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