select * from [table_name] where [field_name] > getdate()
Regards,
Santhosh

> ----------
> From: Justin Gilli[SMTP:[Email Address Removed] Sent: Saturday, May 24, 2003 3:00 AM
> 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