3
Answers

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

Pritesh Bhoi

Pritesh Bhoi
5y
768
1

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)
Next Recommended Forum