Pritesh Bhoi

Pritesh Bhoi

  • 1.9k
  • 51
  • 1.3k

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'.

Brought to you by: JavaScript SDK for Bold BI dashboard and analytics embedding. Free trial.

Answers (3)