Loading

Datetime

Ilkin East

Hi,

I want to compare int month with - database datetime columns.Need Your help.There are datetime column.I want to compare them with datetime.month from textbox.

Thanks in advance.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Anil Kumar14y ago
Accepted answer
Use MONTH function as -

SELECT MONTH(myFieldNameWithDateTimeDataType) FROM myTabeName
0