To quote Morris Day "What time is it?" I know, I'm dating myself with a

1980's R & B music quote, but I've got a bunch of old-school tunes on the

iPod today. I make no apologies. lol

Beware: a date isn't always a date, and getdate() is a datetime. How is

the data stored? Are you calling a stored proc or sending a sqlcommand

from VFP?

Lou

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On

Behalf Of Fred Taylor

Sent: Wednesday, May 11, 2011 10:25 AM

To: profoxtech@leafe.com

Subject: Re: transact sql

See getdate().

Fred

On Wed, May 11, 2011 at 10:07 AM, Rafael Copquin

<rcopquin@ciudad.com.ar>wrote:

> What is the transact sql equivalent of the date() function?

>

> How would you change the following vfp statement into a transact sql

> statement?

>

> select * from invoices where invdate = date()

>

>

> Rafael Copquin

>

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/038e01cc1003$3d66b7f0$b83427d0$@com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.