GetDate() function does not return Current Date in SQL nor in VB.Net

Question

GetDate() function does not return Current Date in SQL nor in VB.Net

Simon 446

The GetDate() function until now, worked beautifully to return the current date, both in SQL as well as in VB.Net.

However, this code has stopped functioning and no longer returns the current date.

What can this mean?

When I try using a different code { fn CURDATE() }, in SQL it sometimes works, but when I want to AddDate function in SQL, I get a message that the returning date from the code { fn CURDATE() } is not a date, it's text. Even if I convert it to Date, it still generates the message that it is text and not a date.

Why did the GetDate function stop working?

Erland Sommarskog 120.4K Reputation points MVP Moderator

2023-12-26T19:13:14.5633333+00:00

Can you clarify what you mean with "stop functioning"? Do you get an error message? Unexpected results? Something else?
Simon 446 Reputation points

2023-12-26T19:28:39.99+00:00

Thank you for your response.

The code GetDate does not give me the current date. When I make a query , for example:

SELECT TOP (100) PERCENT InvoiceID, Acnt, ID, Date, [Check], FormOfPmnt AS Fop, Payment AS SumePaid, ExPD AS Vendor, PayRl AS worker, Pdd AS Tenant, Distrib AS Owner, 1 AS Spzt

FROM dbo.IncomeT

WHERE (Payment > 0) AND (Date = GETDATE())

it does not bring me the current date information.

If I use a different code to get the current date, for example:

SELECT TOP (100) PERCENT InvoiceID, Acnt, ID, Date, [Check], FormOfPmnt AS Fop, Payment AS SumePaid, ExPD AS Vendor, PayRl AS worker, Pdd AS Tenant, Distrib AS Owner, 1 AS Spzt

FROM dbo.IncomeT

WHERE (Payment > 0) AND (Date = { fn CURDATE() })

It will return the current date, but this function { fn CURDATE() } does not return the current date when I try to use the code AddDate.

I look forward to your reply,

Accepted answer

0 additional answers

Your answer

Erland Sommarskog 120.4K Reputation points MVP Moderator

2023-12-26T19:13:14.5633333+00:00

Can you clarify what you mean with "stop functioning"? Do you get an error message? Unexpected results? Something else?
Simon 446 Reputation points

2023-12-26T19:28:39.99+00:00

Thank you for your response.

The code GetDate does not give me the current date. When I make a query , for example:

SELECT TOP (100) PERCENT InvoiceID, Acnt, ID, Date, [Check], FormOfPmnt AS Fop, Payment AS SumePaid, ExPD AS Vendor, PayRl AS worker, Pdd AS Tenant, Distrib AS Owner, 1 AS Spzt

FROM dbo.IncomeT

WHERE (Payment > 0) AND (Date = GETDATE())

it does not bring me the current date information.

If I use a different code to get the current date, for example:

SELECT TOP (100) PERCENT InvoiceID, Acnt, ID, Date, [Check], FormOfPmnt AS Fop, Payment AS SumePaid, ExPD AS Vendor, PayRl AS worker, Pdd AS Tenant, Distrib AS Owner, 1 AS Spzt

FROM dbo.IncomeT

WHERE (Payment > 0) AND (Date = { fn CURDATE() })

It will return the current date, but this function { fn CURDATE() } does not return the current date when I try to use the code AddDate.

I look forward to your reply,

Answer 1

Erland Sommarskog 120.4K MVP Moderator

This condition

(Date = GETDATE())

will only match if the Date column has a value which is exactly the same down to the millisecond as the current time.

When I run SELECT getdate() right now, I see this:

User's image

But it will only take 3-4 milliseconds before that value changes.

Assuming that the column Date only has a date and no time portion, you need to use:

Date = CAST(getdate() AS date)

By the way, that TOP(100) PERCENT in your query is fairly meaningless.

By the way2, you had posted an Answer. Answers are for answers to the original question. You would only post an Answer if you find the solution yourself. I have converted you Answer to a comment.

Simon 446 Reputation points

2023-12-26T20:03:58.9866667+00:00

thanks a milion

Share via

GetDate() function does not return Current Date in SQL nor in VB.Net

0 additional answers

Your answer