MS SQL: How to get the System Date

Yep, totally forgot about this, wish they could have the same function as .NET (datetime.now) but they dont,
but simply its just: GETDATE()

Few other ways are mentioned in this Blog entry: Journey to SQL Authority with Pinal Dave