How to get just the date part of getdate()?

Sep 6 2019 6:40 AM

I have a SQL table that has a CreationDate field.

I have getdate() in the computed column specification formula.

I would like to know how to get just the date portion, that is, '2012-08-24' instead of '2012-08-24 10:45:17.740'.

Answers (3)