Got it Thanks All!


-----Original Message-----
From: Justin Gilli
Sent: Friday, May 23, 2003 12:00 PM
To: LazyDBA.com Discussion
Subject: Need To use a system date in query

All,

I am trying to write a query that shows all data greater then today's date.
I do not have a field in the table for date so I need to use a system date of some kind.

Something like this:

Select * From Accounts
Where AccountDate > {SysDate]

Please advise.

Justin



Sincerely,

Justin Gilli
systems administrator
Wood Flooring International
1810 Underwood Blvd.
Delran, NJ 08075
856-764-2501 ext. 119
856-705-1177 (direct fax)
[Email Address Removed] (e-mail)
www.wflooring.com <http://www.wflooring.com/> (web)





MS Sql Server LazyDBA home page