How can I convert datatime to int data type with GETDATE() function?

Question

I have two problems.

Have you do a quick search before asking the question here ? — Squirrel, Jun 22 '21 at 05:05
See here: https://stackoverflow.com/a/113055 and here: https://stackoverflow.com/a/4141515 — Carsten Massmann, Jun 22 '21 at 05:15
What integer do you want for which date? Your question is not clear. — Gordon Linoff, Jun 22 '21 at 12:14

score 0 · Answer 1 · answered Jun 22 '21 at 05:17

0

Just use the following queries:

Q1:How can I get Today's date without time ?

SELECT CONVERT(DATE, GETDATE());

Q2:How can I convert datetime type into int type ?

SELECT YEAR(GETDATE()) * 10000 + MONTH(GETDATE()) * 100 + DAY(GETDATE())

answered Jun 22 '21 at 05:17

Salahuddin Ahmed

GuidoG · Answer 2 · 2021-06-22T07:57:16.710

Dates are stored as a decimal value, you did not specify how you want to construct your int.

Do you want the actual decimal value ?
you can see the value like this

select CONVERT(float, getdate())

if you only need the date, then this can help

select convert(int, convert(datetime, convert(date, getdate())))

or

select convert(int, getdate(), 112)

Both methods will return an int value for the given date.
For 22/06/2021 this will return 44367

or if you just want to convert the formatted value, then the easiest way is this

select convert(int, Convert(CHAR(8), getdate(), 112))

For 22/06/2021 this will return 20210622

2 Answers2