msSQL Getdate() question

CodeCharge Studio

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

msSQL Getdate() question

Author

Message

MikeL

Posted: 08/08/2002, 1:00 PM

[I'm a newbie to SQL]
I'm trying work with the following code:
UPDATE REQ SET REQ.STATUS = 'OverDue'
WHERE DUEDATE <= GETDATE()
GO

My DUEDATE field is formatted M/D/YYYY HH:MM:SS AM/PM. The code will only chage records if the DUEDATE field contains a date formatted like M/D/YYYY. I really need to include the time in this calculation. Can anybody help?

TIA

Tom

Posted: 08/09/2002, 4:56 AM

Mike,
but GETDATe() returns seconds as well...

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login