Re: DatePart

From: Bob Hairgrove <wouldnt_you_like_at_to_know.com>
Date: Fri, 20 Feb 2004 14:38:39 +0100
Message-ID: <d93c309u0o59f19lni3kf5do0jp0h6274q@4ax.com>

On Fri, 20 Feb 2004 03:24:38 GMT, "mountain man" <hobbit_at_southern_seaweed.com.op> wrote:

>What language is this?

MSAccess also has a DatePart() function. However, it's not portable (neither is the date syntax #...#).

>The original post specified the *datepart()* function.
>This is a standard function in SQL server.

So maybe not everyone uses SQL Server, either. I tried to suggest a solution which (except for the #...#) would work in other environments as well.

--
Bob Hairgrove
NoSpamPlease_at_Home.com

Received on Fri Feb 20 2004 - 07:38:39 CST