RE: Need To use a system date in query

RE: Need To use a system date in query

 

  

Justin,

GetDate() will return the current system date and time

Your query should look like this

Select * From Accounts
Where AccountDate > GetDate()

Thanks

Dave Sueltenfuss
Application Developer
Certified ColdFusion MX Developer
Arch Wireless
Phone: 508-870-6711
Fax: 508-870-8011
Email: dave.[Email Address Removed] Message-----
From: Justin Gilli [mailto:[Email Address Removed]
Sent: Friday, May 23, 2003 1: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